what are Joins? How many types are there?
- 8 Answers
- 23500 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
How to specify a client for database table processing?
What is the difference between pnp and pnpce? : abap hr
On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?
Define batch input session?
What are the data types of internal tables?
Explain about sap fico testing and the tools used? : abap bdc
what are the critical issues u face in ur project?
What are the types of views? : sap abap data dictionary
When to use logical database?
Difference between sy-tabix and sy-index?
What are screen painter and menu painter? : abap hr
What are the differences between the table and the structure in the data dictionary in the sap abap?
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul
