Joined Table
Joined tables are used in a select statement to combine data from two or more tables that share one or more columns.
With Open SQL for Java you can use inner join and left outer join.
THERE ARE 2 TYPES OF JOINS, INNER AND OUTER JOINS.
Inner Join:
In case of inner join there should be an entry in all the tables use in the view.
Outer Join:
With the use of outer join you can join the tables even there is no entry in all the tables used in the view.
Syntax:
inner join :
select P<fieldname> d<fieldname> into corresponding fields of table <internaltable> from ( <table> as p inner join <table> as d on <join condition> and <cond>.
Eg.
suppose tables LFA1 ,EKKO.
select alifnr aname1 a~ort01
bebeln bebelp
from a as LFA1 inner join b as EKKO on
alifnr = blifnr.
OUTER JOIN
in the outer join the results may also contain entries that donot have corresponding entries in both the tables that comprise the join instead they are present in any of the one
SYNTAX
outer join:
select P<fieldname> d<fieldname> into corresponding fields of table <internaltable> from ( <table> as p left outer join <table> as d on <join condition> and <cond>.
LEFT OUTER JOIN
At LEFT OUTER JOIN, results tables can also contain entries from the designated left hand table without the presence of corresponding data records (join conditions) from the table on the right. These table fields are filled by the database with null values and are then initialized according to ABAP type.
RIGHT OUTER JOIN
At RIGHT OUTER JOIN, results tables can also contain entries from the designated right hand table without the presence of corresponding data records (join conditions) from the table on the left. These table fields are filled by the database with null values and are then initialized according to ABAP type
Bluesky
