Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
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
outer join in query JD Excel Discussion (Misc queries) 0 June 10th 09 07:35 PM
Join tables like inner join in Access ryanp Excel Discussion (Misc queries) 2 July 18th 08 03:35 PM
Require help related to Excel Query outer join problem CJ Excel Discussion (Misc queries) 0 August 2nd 07 02:32 AM
MS Query Outer join with three tables Jim Excel Discussion (Misc queries) 0 February 15th 07 09:52 PM
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


All times are GMT +1. The time now is 03:06 AM.

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

About Us

"It's about Microsoft Excel"