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
Differentiate between abap memory and sap memory?
What are the aggregate objects in the dictionary? : abap data dictionary
The max number of calling modes stacked at one time is?
How can you access the function code from menu painter?
What is a transport?
Describe data classes? : abap hr
What do you do when the system crashes in the middle of a BDC batch session?
Can matchcode object contain ids with different update types? : abap data dictionary
How table control cn be generated using bdc? : abap bdc
What is the use of table control in bdc is it same in module pool table control? : abap bdc
What are the different functions used in sap script? What are the parameters used in each function?
How will you define posting procedures?
Is it possible to pass data to and from include programs explicitly? : abap modularization
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
What is meant by hide area?