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 the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary
What are the techniques involved in using sap supplied programs?
What is the difference between skip and new-line?
Why do we use abstract class
what is user specific parameter?
Cds views
What is maintenance view?
Can a domain, assigned to a data element be changed?
How to combine multiple order in one Delivery ( Step by Step)?
I need some information regarding Vcentric Test pattern ? with questions.
Explain Singleton class
What is an update type with reference to a match code id?
What is the difference between field-group header and other field groups?
Different types of locks?
What are the advantages/ dis-advantages of logical databases?