joins-abap

  JOINS ARE USED TO FETCH THE DATA FROM   MORE THEN  ONE   DATABASE TABLES

                   THERE ARE TWO  TYPES OF JOINS

                      1) INNER JOIN

                      2)  LEFT OUTER JOIN

1) INNER JOIN :   Inner join  picks the  data from both  the tables  if and only  if  there is one (or) more  then one entry is available in  right  hand side  table  with  corresponding  to left hand side table.

INNER JOIN

 2) LEFT OUTER JOIN :  Left outer join  picks the data from left hand side table even though  tere is no match found  in right hand side table and left outer join is  only possible for two database tables.

LEFT OUTER JOIN