Outer Joins msquery vs access

[John Beecroft]

I have been able to write a query in Access with 5 tables
and 4 outer Joins. I cannot write the same query in
msquery because outer joins are not allowed when more than
2 tables are used. According to KB the limitations of
msquery are in the particular ODBC driver not msquery. How
come the same driver allows such things in access and not
msquery? It seems like there are limitations to
msquery...where can I find a comprehensive list of msquery
limits?
Thanks

 

[[MVP] S.Clark]

MSDN or maybe the msquery help file.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-