At 5:52 AM -0500 1999/11/30, Jeff Thies wrote:
> Got a dumb join question.
>I've got this:
>SELECT table1.field1,table1.field2,table2.field3 FROM table1,table2
>WHERE table1.id_field=table2.id_field AND some_field=some_condition AND
>basically I'm just trying to retrieve some extra info from table2.
>The SQL works without the join. Nothing gets returned after the join.
>table1.id_field is a UNIQUE INDEX, table2.id_field is not indexed
>What have I done wrong?
You're apprently asking for rows in which some_field is both of two
different values, which is impossible.
Paul DuBois, paul@stripped