List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 30 1999 12:42pm
Subject:Re: join confusion
View as plain text  
At 5:52 AM -0500 1999/11/30, Jeff Thies wrote:
>   Hi,
>
>   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
>some_field=some_other_condition
>
>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
Thread
join confusionJeff Thies30 Nov
  • Re: join confusionTonu Samuel30 Nov
  • Re: join confusionPaul DuBois30 Nov