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
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
What are standard layouts sets in the sap script?
What happens if only one of the commands set screen and leave screen is used without using the other?
What are the requirements a dialog program must fulfill?
What is the difference between table and template?
What is roles and responsibilities of sap hr consultants? : sap abap hr
What is the difference between a substructure and an append structure? : abap data dictionary
Does every abap/4 have a modular structure? : abap modularization
Why bapi need then bdc ? : abap bdc
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
Differentiate between the uline and write: sy-uline statements if any?
What is the function of the correction system? : abap data dictionary
PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..
What is luw or data base transaction ?
What are the different types of locks? : abap data dictionary