what are Joins? How many types are there?

Answer Posted / rabindra

Joins are 2 types. INNER JOIN, OUTER JOIN.

Inner Join:
In case of inner join there should be an entry in all the
tables use in the view.

Outer Join:
With the use of outer join you can join the tables even
there is no entry in all the tables used in the view.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Advantages and disadvantages of different types of bdc's?

564


What is the difference between call transaction and session method? : abap bdc

646


How many lists can a program can produce?

582


How many secondary indexes can we create in a table?

609


What are the differences between table controls and step loops?

544






Can you create a table with fields not referring to data elements? : abap data dictionary

763


Does sap handle multiple languages?

544


what is call back in alv?

1965


Explain the properties of selection screen?

640


Can a transparent table exist in data dictionary but not in the database physically? : abap data dictionary

694


how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.

4761


Events that can be used in both the classical and interactive reports

1107


What is open sql?

568


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

575


What is the difference between collect and append statements?

549