what are Joins? How many types are there?
- 8 Answers
- 23417 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / sudhakar1207
Joins are used to extract data from more than one DB table
which are logically related to each other.
So in order to join DB Tables they should have a common
field or attribute.
In ABAP, We have two types of Joins.
1) Inner Joins
2) Outer Joins ( Left Outer and Right Outer)
Inner Joins retrieve the records which matched with join
condition only.
While outer joins Retrieve the records which are matched
with Join Condition and Remaining records from the Parent Table.
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What abap statement will trigger list generation?
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
How many ways can a sap system be accessed?
Explain the systems fields used for interactive lists and lists?
Explain the session method? : abap bdc
What is a development class? : abap data dictionary
How we can give authorization on the fields of table control in a dialog-programming?
What are number ranges?
What are match codes? describe?
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 is the difference between sum and collect?
How to know if the value entered contains records or not?
How will you define org structure in MM?
