Types of joins ?

Answer Posted / chandu

5 Types [7.x]

Equi Join
Cartesian Join
Non Equi Join
Outer Join
Self Join

8 Types [9i]

Natural Join
Join with Using
Join with on
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a unique key and primary key and foreign key?

564


How do I remove sql plus from windows 10?

561


In pl/sql, what is bulk binding, and when/how would it help performance?

524


What is file based approach?

483


Can we use delete in merge statement?

510






Which kind of parameters cannot have a default value in pl sql?

587


What are the benefits of stored procedures?

528


What are the different tcl commands in sql?

615


what is column? : Sql dba

562


what is the difference between $message and $$message? : Sql dba

541


what is 'mysqladmin' in mysql? : Sql dba

526


How many tables can a sql database have?

526


How do you use collections in procedure to return the resultset?

1782


What is the importance of sqlcode and sqlerrm?

838


Explain aggregate functions are available there in sql?

528