[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