Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

joins four types..can we use all in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kumar119119

New User


Joined: 31 May 2010
Posts: 25
Location: Pune

PostPosted: Mon Jun 28, 2010 11:18 pm    Post subject: joins four types..can we use all in DB2
Reply with quote

Hi Folks,
Good Evening to All,

in DB2 joins are

inner join
left outer join
right outer join
full outer join

my question is

can we use/can all these used in DB2,
if used at which scenario,,not definition of four joins?

From
Satish kumar reddy.T
Bangalore.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jun 29, 2010 1:19 pm    Post subject:
Reply with quote

I know I can .
Right Join can also be written as left join. So there is no need ever to use Right join.

when Inner, when Left, when Full outer ? It depends on the business requirement.
"Give me all entity1 with their entity2's" is a typical inner join.
"Give me all entity1 and if they have entity2's give those too" is a typical left join.
"list me all entity1 and entity2 with the differences" is a typical full outer join
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Jun 29, 2010 2:07 pm    Post subject:
Reply with quote

Well phrased, Guy
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Types of variables REXX tvinodkumar7 TSO/ISPF 2 Wed Aug 26, 2015 6:57 pm
No new posts Need help in Joins rajendra kalepu JCL & VSAM 9 Wed Oct 30, 2013 10:11 pm
No new posts Personal Comm. - User Defined Transfe... Div Grad IBM Tools 6 Wed Mar 06, 2013 2:06 am
No new posts File Manager reading file with differ... madmartinsonxx IBM Tools 1 Wed Jan 23, 2013 11:55 pm
No new posts Component Types In Endevor srinut123 CA Products 1 Thu Aug 09, 2012 12:17 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us