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
Of the two call transaction and session method, which is faster?
What is a bsp application? : sap abap hr
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
What are the functional areas? User groups?
What kind of financial periods exist in sap? What is the relavent table for that?
How many ways can a sap system be accessed?
What are the attributes of the data in data dictionary? : abap data dictionary
What do you understand by work area and internal tables in abap? Why do we use it?
Can I execute user exits? If yes, how?
Can matchcode object contain ids with different update types? : abap data dictionary
Can i have some Realtime Scenarios on Reports.
What is check table?
What is the use of dequeue function module? : sap abap data dictionary
What is an update type with reference to a match code id?
What is the difference between a structure and a table? : abap data dictionary