Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Query: Looking for a work-around to 2-table limits for outer jo Jim Excel Discussion (Misc queries) 0 December 27th 06 07:41 PM
How import multiple tables from same web page (Web Query)? [email protected] Excel Discussion (Misc queries) 2 March 8th 06 11:41 PM
MS Query No visible tables ChrisP Excel Discussion (Misc queries) 3 September 6th 05 08:51 PM
Web Query from multiple tables jjbf22 Excel Discussion (Misc queries) 0 July 29th 05 03:28 PM
Two Excel tables in MS Query Jamshed Excel Discussion (Misc queries) 0 June 24th 05 12:33 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"