Home > DeveloperSection > Interviews > Types of join

Posted on    October-26-2010 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 2 Answer(s)
  1015  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Points:1205
Posted on    October-26-2010 12:00 AM

  • JOIN: Return rows when there is at least one match in both tables
  • LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table
  • RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table
  • FULL JOIN: Return rows when there is a match in one of the tables


Pushpendra Singh

Total Post:241

Points:1205
Posted on    October-26-2010 12:00 AM

We have three types of Joins in sql.
They are
1. Inner join
2. Outer join
3. Cross join

Outer join is further classified as three types.They are
1.left outer join
2.right outer join
3.full outer join.


Don't want to miss updates? Please click the below button!

Follow MindStick