Give the syntax of Inner,outer Join?"
- 7 Answers
- 32425 Views
- Genpact, HCL, Satyam, I also Faced
- E-Mail Answers
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
where are the passwords for ITS stores?
Which transaction code is used executing a report (type 1 program)? : abap data dictionary
What are the steps in a bdc session? : abap bdc
Can we define our own match code id's for sap matchcodes? : abap data dictionary
What are the value tables?
Difference between call by value and call by reference? : abap data dictionary
What is an abap data dictionary? : abap data dictionary
ABAP : Classical reports events name
when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.
What are the two ways of producing a list within a transaction?
Can a posting run be deleted? : sap abap hr
What’s value table?
What is the difference between data elements and domains?
How to call a subroutine in sapscript?
What are the different modules of sap? : sap abap hr
