Re: Left Joins with Linked Tables
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2005 10:25:30 +0800
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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"carl" <carl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8811FA97-7AE3-4B97-B123-0C98915A0AB5@xxxxxxxxxxxxxxxx
>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??
.
- References:
- Left Joins with Linked Tables
- From: carl
- Left Joins with Linked Tables
- Prev by Date: Left Joins with Linked Tables
- Next by Date: Re: Field Name Query Help
- Previous by thread: Left Joins with Linked Tables
- Index(es):
Relevant Pages
|
|
