List:General Discussion« Previous MessageNext Message »
From:Kaj Schermer Didriksen Date:September 5 2007 2:38pm
Subject:Left join problem
View as plain text  
two tables gi_t and gi

gi_t holds 5 records. gi holds ca. 1500.

I need all from gi for each in gi_t ie LEFT JOIN!!!
but this:
SELECT AS id, overskrift,gidata FROM gi_t LEFT JOIN gi ON WHERE bladref=137
gives the same as
SELECT AS id, overskrift,gidata FROM gi_t ,gi WHERE AND bladref=137

I want 5 records (3 ok, and 2 NULL) and I get 3. the 3 that has a  
relation in gi

Kaj Schermer Didriksen
Left join problemKaj Schermer Didriksen5 Sep
  • RE: Left join problemJerry Schwartz5 Sep
  • Re: Left join problemMartijn Tonies5 Sep