IBM Mainframe Forum

Please any one explain about INNER JOIN & OUTER JOIN IN DB2

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.

thank you

in inner join t gives the matchng rows bt in outer joins t also shows the unmatchd rows