Left Joins with Linked Tables

C

carl

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??
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ambiguous outer join 6
Left Join Not Returning All Records 2
Left Join query not working in Access 2010 0
Nested JOIN clauses - order of precedence (Access 2007) 2
A bug in GUI of creating query with more outer joins between two tables 5
Forcing an ambiguous outer join 6
Can't add records to statement with two many-to-many joins. 3
Joins on NULL Date values 3

Top