what are Joins? How many types are there?

Answer Posted / arun prasad

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are authorization objects and what statement is used to perform an authorization check in an abap program?

568


What is the use of info groups? : sap abap hr

564


What is step-loop? Explain all the steps?

548


What is filter dependent BADI?

930


Explain the inside concept in select-options?

564






Does sap handle multiple languages?

562


Define alv programming in abap?

702


Explain get pernr concept when we use logical data base? : abap hr

757


What is personnel sub are

1578


What is table attribute? : abap data dictionary

573


What is the difference between a substructure and an append structure?

629


i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status

8506


What are the different attributes that can be assigned to a variant?

587


How do you get the number of lines in an internal table? How to use a specific number occurs statement?

527


what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary

618