Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How many join types in sql?

user-image
Question added by Deleted user
Date Posted: 2013/09/21
Mahmoud Mamdouh
by Mahmoud Mamdouh , Linux System Administrator (Remote position) , 2X4.ru

and dont forget NATURAL JOIN

Naresh kumar
by Naresh kumar , Sr. Software Engineer , vayamtech

Basically its Four Type of Join

1, Inner Join

2. Outer Join

 a. Let Outer Join

 b. Right Outer Join

c. Full Outer Join

3. Cross Join

Feras Elias
by Feras Elias , Technical Support Officer , Legal Affairs Department

1.InnerJoinor Equi join

2. Self Join

3.OuterJoinouterjoinis again classified into

   a)LeftOuterJoin

   b)RightOuterJoin 

   c)FullOuterJoin

4.Crossjoin

Deleted user
by Deleted user

Good Feras...but there are other4 join relations :)

More Questions Like This