Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Query: Looking for a work-around to 2-table limits for outer jo | Excel Discussion (Misc queries) | |||
How import multiple tables from same web page (Web Query)? | Excel Discussion (Misc queries) | |||
MS Query No visible tables | Excel Discussion (Misc queries) | |||
Web Query from multiple tables | Excel Discussion (Misc queries) | |||
Two Excel tables in MS Query | Excel Discussion (Misc queries) |