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 are some emotional triggers?

745


What are different types of keys?

732


What is the meaning of disabling a trigger?

822


Is postgresql a server?

730


What is sqlservr exe?

683






Is sql workbench free?

708


What is the difference between sql, mysql and sql server?

694


What is the order of sql select?

761


Mention what pl/sql package consists of?

718


What is cascade in sql?

702


explain the difference between myisam static and myisam dynamic. : Sql dba

701


What is Difference Between Unique and Primary Key Constraints?

822


What is the difference between delete, truncate and drop command?

743


What is the requirement of self-join?

737


How do I enable sql encryption?

712