Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outer join with 3 tables using MS Query
I am trying to do an outer join of three tables, using MS Query. I
understand that this is possible, but that I must modify the SQL code. The following SQL code was generated by MS Query to perform an outer join of two tables, Table_Field1 and Table_Field2. 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 the above code to extend the outer join by also joining a third table, Table_Field3, which contains a field named Field3 to be included in the final query result file? Many thanks for your advice! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
outer join in query | Excel Discussion (Misc queries) | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
Require help related to Excel Query outer join problem | Excel Discussion (Misc queries) | |||
MS Query Outer join with three tables | Excel Discussion (Misc queries) | |||
MS Query: Looking for a work-around to 2-table limits for outer jo | Excel Discussion (Misc queries) |