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 difference between (internal table types)standard table and sorted table in sap abap....
Can a filed occur in several field groups?
What are the uses of the information in the data dictionary? : abap data dictionary
What is an abap/4 query? : abap hr
How many secondary indexes can we create in a table?
Difference between open sql and native sql? : abap data dictionary
What are the major steps will you use for tuning?
What are the restrictions on subscreens?
How many types of tables exists and what are they in data dictionary? : abap data dictionary
Is it possible to pass data to and from include programs explicitly? : abap modularization
Can you print decimals in type n?
What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?
In what ways we can get the context sensitive f1 help on a field?
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
Which database object is used for storing the system variables? : abap data dictionary