[thelist] Nested Left Outer Join in Access ?

rudy r937 at interlog.com
Fri Aug 17 11:53:16 CDT 2001


hi matt

dunno what happened, i wrote this last night but only just now noticed it
sitting in my Drafts folder unsent...

hope it is still helpful


> Since you can't do left outer joins like this [h.host_id *= hs.host_id]
> in Access

yeah, that syntax is not recognized

use LEFT JOIN instead

note:  you can nest LEFT JOIN in an INNER JOIN but not the other way round


rudy






More information about the thelist mailing list