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

Reply via email to