Outer Join



IBM's flagship relational database management system

Outer Join

Postby KRISHAN » Thu Oct 07, 2010 5:17 pm

Please any one explain about INNER JOIN & OUTER JOIN IN DB2
KRISHAN
 
Posts: 6
Joined: Wed Oct 06, 2010 6:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outer Join

 

Re: Outer Join

Postby Robert Sample » Thu Oct 07, 2010 5:23 pm

INNER JOIN and OUTER JOIN are part of the standard SQL definition and are not specific to DB2. Google is your friend -- Googling inner join outer join finds 387,000 hits and several on the very first page explain the concepts nicely.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

Re: Outer Join

Postby KRISHAN » Thu Oct 07, 2010 5:49 pm

thank you
KRISHAN
 
Posts: 6
Joined: Wed Oct 06, 2010 6:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outer Join

Postby RENGANATHAN » Sat Nov 20, 2010 8:09 am

in inner join t gives the matchng rows bt in outer joins t also shows the unmatchd rows
learner(admin)
RENGANATHAN
 
Posts: 9
Joined: Thu Jul 29, 2010 2:23 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post