what are Joins? How many types are there?

Answer Posted / 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
condition only.
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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the advantages and disadvantages of different types of bdc's?

610


How to add a column to a table control while using alphanumerical layout editor ?

1794


What is asap methodology? : sap abap hr

576


What are the different types of abap reports in sap?

777


What is use of transparent table in abap? How it is different from pool tables?

643






How many types of views are there? : abap data dictionary

564


How do you find the information on the current screen? : abap bdc

615


Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

637


What will you code in start-of-selection & end-of-selecton & why?

592


What is the difference between pnp and pnpce? : abap hr

1096


What are the events in screen programming?

626


Explain the difference between call screen and leave screen?

609


What is hotspot?

931


What is your current client number?

607


What is collective search help? : sap abap data dictionary

614