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 |
Is BAdI client Indpendent
Under Data Transfer Portion of ABAP, what do you mean by DX Project
What are authorization objects and what statement is used to perform an authorization check in an abap program?
Specify the types of data dictionary objects.
How to pass data from list to report?
Reuse-ALV-list display?
we can use internal table with help of user define data types if possible or not
what is the main difference between lsmw and bdc ? in which situation we will go for lsmw instead of bdc?
What are field groups?
What are Standard Texts?
What is the name of ur presentation,application server in ur comp???
How to test a script?how to find versions in scripts?