ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query Outer join with three tables (https://www.excelbanter.com/excel-discussion-misc-queries/130940-ms-query-outer-join-three-tables.html)

Jim

MS Query Outer join with three tables
 
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?
--
Jim


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com