| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Kaj Schermer Didriksen | Date: | September 5 2007 2:38pm |
| Subject: | Left join problem | ||
| View as plain text | |||
Hi 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 gi.id AS id, overskrift,gidata FROM gi_t LEFT JOIN gi ON gi_t.id=gi.gitref WHERE bladref=137 gives the same as SELECT gi.id AS id, overskrift,gidata FROM gi_t ,gi WHERE gi_t.id=gi.gitref AND bladref=137 I want 5 records (3 ok, and 2 NULL) and I get 3. the 3 that has a relation in gi why? Regards Kaj Schermer Didriksen
| Thread | ||
|---|---|---|
| • Left join problem | Kaj Schermer Didriksen | 5 Sep |
| • RE: Left join problem | Jerry Schwartz | 5 Sep |
| • Re: Left join problem | Martijn Tonies | 5 Sep |
