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 asSELECT 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