Interested to Buy Any Domain ? << Click Here >> for more details...
Give the syntax of Inner,outer Join?"
- 7 Answers
- 34608 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 is meant by authorization? : sap abap hr
What is the difference between field-group header and other field groups?
1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?
What is singleton pattern in OOPS?
What is difference between dependent and independent data?
identify valid statement when coding a field exit ? a) submit RSCA101X b)MESSAGE E101 C)MESSAGE I101 d)BREASK-POINT
How to find the return code of an stmt in abap programs?
What are function modules?
How many secondary indexes can we create in a table?
hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display
How do you display a data in a detail list?
What happens if we use leave to list-processing without using suppress-dialog?
What are the tcodes for performance tuning?
How do you get the number of lines in an internal table?
What are the page headers for secondary lists?
