what are Joins? How many types are there?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rabindra
Joins are 2 types. INNER JOIN, OUTER JOIN.
Inner Join:
In case of inner join there should be an entry in all the
tables use in the view.
Outer Join:
With the use of outer join you can join the tables even
there is no entry in all the tables used in the view.
Is This Answer Correct ? | 11 Yes | 4 No |
IF WE WANT TO GET THE DATA FROM SOME TABLES WHICH HAS SOME
RELATIONS BETWEEN THOSE THEN WE USE JOINS TO GET THE DATA
BY USING THOSE PRIMARY KEYS.
THERE ARE 2 TYPES OF JOINS, INNER AND OUTER JOINS.
INNER IS USED TO GET THE DATA WHERE THE TABLES ARE IN SAME
DATABASE AND OUTER JOIN IF THEY ARE IN OTHER.
Is This Answer Correct ? | 11 Yes | 8 No |
Answer / anu
joins are 2 types.
1.inner join:
inner join is same as join.
2.outer join
i.left outer join
ii.right outer join
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / yaswant chauhan
join is the fetch the data from more than one table
it is three types
1- inner join
2- outer join
3- cross join
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / sarvesh
Joins are two types:
1- Inner join : Normal join
2- Outer join (Left and Right)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sunil panghal
Joins are three type in sap abap
1 inner join
2 for all entries
3 subqueries
Is This Answer Correct ? | 1 Yes | 0 No |
How to do back ground processing in BDC Session method ?
MM Flow & SD Flow
7 Answers Accenture, Cap Gemini, IBM, SAP Labs,
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
what connects smartform to it's driver program?
what is an user exit?
what is the transaction code used for triggering sap script ?
How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?
How to decide whether we can use BDC (OR) LSMW for a given transaction?
What should be the approach for writing a bdc program? : abap bdc
How do you read the data from clusters
How would you debug custom programs at runtime?
what is version management in sap abap.Do we have this concept in scripts also?if at all then how do you handle in scripts and what's its usage