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

How to creat transactions? : abap data dictionary

632


Differentiate database index and match code.

583


What functions does a data dictionary perform ?

551


what are the two methods of modifying sap standard tables ?

545


What data is contained? : abap data dictionary

675






Why is pretty printer user in abap?

624


Is it possible to pass data to and from include programs explicitly?

575


Does the call transaction method allow multiple transactions to be processed by sap?

547


What are the different types of view?

586


What are the features of abap/4 dictionary? : abap data dictionary

567


What is an abap?

540


Explain what are interactive reports?

612


Why do we use FOR ALL ENTRIES and what is the pre-requisite

908


What is dynpro? what are its components ?

607


What are the two different ways of building a match code object?

574