MS Query Outer join with three tables

J

Jim

I've seen references stating that MS Query can perform an outer join withy
three tables, if the SQL is properly adapted.

Following is the MSQuery-generated SQL for an outer join with only two tables:
SELECT Table_Field1.ID, Table_Field1.Field1, Table_Field2.Field2
FROM {oj Table_Field1 Table_Field1 LEFT OUTER JOIN Table_Field2 Table_Field2
ON Table_Field1.ID = Table_Field2.ID}

How would I modify this SQL code to add a 3rd table named Table_Field3,
containing the same common ID field as in the two original tables, and also
containing a field named Field3 to be also included in the query result?
 

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

Outer join with 3 tables using MS Query 0
MS Query - Joining two tables.... 1
MS Query Joins 1
Ambiguous outer join 6
A bug in GUI of creating query with more outer joins between two tables 5
To give inner join and Left outer Join 3
Can't outer join or append. 2
Outer Join and a two step query 1

Top