Give the syntax of Inner,outer Join?"
- 7 Answers
- 32590 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
How can a lock object be called in the transaction?
What is the table & field to identify the no of items (bottles) stored in one case?
How do you execute the payroll
What is a bsp application? : sap abap hr
Sy index and sy tabix
What is a type-pool?
why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.
what is a text table ?
What are the steps in creating screen ?
What is an rdbms?
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
What do you do when the system crashes in the middle of a BDC batch session?
What are the difference between call screen and leave screen?
Explain some essential objects in abap dictionary?
What is difference between inner join and outer join?
