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 |
Can you print decimals in type n? What is difference between float and packed data type?
What is the difference between call transaction and session method? : abap bdc
Can we download master data using LSMW method?
Difference between Insert, Update and Modify?
What are RFCs? How do you write RFCs on SAP side?
What is kernal badi? What is the difference between classic badi and kernal badi ? What is the advantages of kernal badi?
2 Answers Accenture, HBL Power Systems, IBM, Yash Technologies,
Name 5 custom objects that dont start with Z or Y ?
What are the modes in lock objects? : sap abap data dictionary
how to capture the errors in bdc Call transaction method?
which processor controls the flow logic of an online program?
What is the typical structure of an ABAP program?
In a script, i want to print something at end of last page only.How can i print it?