Give the syntax of Inner,outer Join?"
- 7 Answers
- 31072 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
What are the dis-advantages of logical databases? : abap hr
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
Can we display a list in a pop-up screen other than full-size stacked list?
Will 50,000 records be uploaded directly into APP's Server?
when do you need to create an internal table with header line ? and with out a header line?
Differentiate between ooabap and abap?
What is an abap data dictionary? : abap data dictionary
What is an “on input filed” statements?
What is an update task? : abap modularization
Difference between domain and data element? What are aggregate object?
How can we achieve MVC ?
What is a projection view? : abap data dictionary
What are data classes? What are the various data classes available for selection? : abap data dictionary
What is IMG in SAP?
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
