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


Please Help Members By Posting Answers For Below Questions

What is the difference between tables and structures?

848


How do you read files from the application server ? : abap bdc

876


What are client dependent objects in abap/sap?

820


Some Realtime Examples on Exits .

1936


what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

2001


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 ?

1734


What are the personnel administration related infotypes? : abap hr

834


How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?

868


What is the significance of technical settings (specified while creating a table in the data dictionary) ?

822


What is a transaction variant and why are they used?

822


How are BAPI different from Normal function modules ?

1852


wat are the process that can be executed & tracked in a workflow?

1914


What are the uses of table pool or table cluster.

740


how to create view in bdc..??

2609


What are the events driven batch jobs?

821