MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Query for left outer join

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
SRI123
Beginner


Joined: 01 Jun 2012
Posts: 1
Topics: 1
PostPosted: Fri Jul 27, 2012 3:11 am    Post subject: Query for left outer join Reply with quote
Three tables A , B, C with A-> C is one to many and B-> C is one to many.

While writing query for left outer join, can we keep all the 'one to' tables on the left side of the join and 'many' table on the right side?

I need to write a query by using left outer join to fetch the data from these tables with data in the C table is matching with A & B

Code:

SELECT A.COL1
      ,B.COL2
      ,C.COL2
 FROM A
     ,B LEFT OUTER JOIN C
   ON A.COL1  = C.COL1
  AND B.COL1  = C.COL1                   


is this correct?

Thanks
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 11186
Topics: 70
Location: San Jose
PostPosted: Fri Jul 27, 2012 11:55 am    Post subject: Reply with quote
SRI123,

Combine both tableA and TableB with an INNER JOIN and then perform the OUTER JOIN on tabeC

untested sql
Code:

SELECT A.COL1                         
      ,B.COL2                           
      ,C.COL2                           
 FROM tablea A INNER JOIN tableb B 
   ON A.COL1  = B.COL1             
 LEFT OUTER JOIN tablec C             
   ON B.COL1  = C.COL1             
;


Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group