what are Joins? How many types are there?
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 happens if a function module runs in an update task?
Explain the disadvantages of logical databases?
What takes most time in SAP script programming?
What are the advantages and disadvantages of ABAP query tool?
State the system field for the current date?
What are the types of subroutines? : abap modularization
What are roles and authorization objects?
Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?
What is a report?
State the differences between database view & projection view? : abap data dictionary
What is read line in abap?
How can you manipulate the presentation and attributes of interactive lists?
Cds views
In which cluster time results are stored? : abap hr
What is the difference between skip and new-line?