Left Joins with Linked Tables

[Guest]

I have problems with left joining:
My SQL statement joins two queries using a left join.
Both of the queries are just a single table - filtered.
Both of the tables are linked from a SQL Server.

Problem is that my SQL will product data consistent with a inner join.
After all my experimenting with making tables etc I reckon my problem is I
can't left join SQL Server linked tables.
Is this correct or am I going nuts??

 

[Allen Browne]

Carl, there are indeed cases where JET is not able to handle outer joins
correctly.

For one documented example, see:
Records missed by SELECT query
at:
http://allenbrowne.com/bug-10.html

Having said that, there are also other possible explanations for the
problem, such as criteria on the fields on the outer side of the join which
suppress the nulls and you validly end up with the equivalent of an inner
join.