View previous topic :: View next topic
|
Author |
Message |
kumar119119
New User
Joined: 31 May 2010 Posts: 25 Location: Pune
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Well phrased, Guy |
|
Back to top |
|
|
|