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 difference between tables and structures?
How do you read files from the application server ? : abap bdc
What are client dependent objects in abap/sap?
Some Realtime Examples on Exits .
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?
What are the personnel administration related infotypes? : abap hr
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
What is the significance of technical settings (specified while creating a table in the data dictionary) ?
What is a transaction variant and why are they used?
How are BAPI different from Normal function modules ?
wat are the process that can be executed & tracked in a workflow?
What are the uses of table pool or table cluster.
how to create view in bdc..??
What are the events driven batch jobs?