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
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.
In case of inner join there should be an entry in all the
tables use in the view.
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|
Answer / me
I dont know
|Is This Answer Correct ?||9 Yes||3 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.
inner join is same as 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
|Is This Answer Correct ?||1 Yes||0 No|
What are the components in sap application server?
What is field catalog. Describe the purpose of it?
Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?
Did u inherit any standard sap programs? what are they? and for what purpose you have done it?
What are the different types of abap reports in sap?
what is the way to find out user exits?
What is BSP Application & Extension?
What is the program flow of BADI(step by step)?
A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary
Explain the table, which contain the details of all the name of the programs and forms?
which command is used to flushes the database buffer?
What is kernal badi? What is the difference between classic badi and kernal badi ? What is the advantages of kernal badi?