ambiguous outer joins

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

How do you create a seperate query that performs the first
join then include that query in your SQL statement? I have
three tables, two are in a one to one join (my first join)
and the the third table I want to join in an outer join so
I get all of the third table and the common entries from
the first two. I tried following the help within Access
but get an error message saying it doesn't like my name
for the first query it is looking for a Select.
 
How do you create a seperate query that performs the first
join then include that query in your SQL statement? I have
three tables, two are in a one to one join (my first join)
and the the third table I want to join in an outer join so
I get all of the third table and the common entries from
the first two. I tried following the help within Access
but get an error message saying it doesn't like my name
for the first query it is looking for a Select.
Click to expand...

Perhaps you could post the SQL of the query that's not working?

If you have tables TableA, TableB and TableC try:

SELECT <some fields>
FROM TableA INNER JOIN TableB
ON TableA.ID = TableB.ID;

Save this as qryAB.

Then write

SELECT <some fields>
FROM TableC LEFT JOIN qryAB
ON qryAB.ID = TableC.ID;
 
Hi Doug,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top