Give the syntax of Inner,outer Join?"
Answer Posted / navneet
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>.
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>.
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What is constructor expression in nw abap 7.4?
What are th control break events in abap?
What is the difference between refresh and free statements?
Why lsmw does not support call transaction method? : abap bdc
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
What are the modes in lock objects? : sap abap data dictionary
What will you code in start-of-selection & end-of-selection ?
How move-corresponding works
What are the two levels in defining a match code? : abap data dictionary
What is the function of a data element?
Fallback class
Explain the structure of a bdc sessions?
Difference between sy-tabix and sy-index?
Define spool request?
What is a data dictionary? : abap data dictionary