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

How can I get ascii value of any letter? Is there any function?

659


Create any functions? How to go about it?

569


What is page window?

582


What are the aggregate objects in the data dictionary? : abap data dictionary

1053


How to know if the value entered contains records or not?

565






How do you use structures in the abap programs?

602


What are differences between at selection-screen and at selection-screen output?

781


What are the update types possible? : abap data dictionary

558


Differentiate screen painter from menu painter.

566


What does the extract statement do in extract datasets? : abap modularization

567


Explain the disadvantage of using exec sql statement in abap?

524


What is going life actually? What is the role of a functional consultant in it? : sap abap hr

556


What is its?

664


What is database utility?

704


What are the Synchronous and asynchronous methods in bdc ?

618