---
title: "Types of join"  
description: "Types of join"  
author: "Pushpendra Singh"  
published: 2010-10-26  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/207/types-of-join  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 2 minutes  

---

# Types of join

- **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

\

## Answers

### Answer by Pushpendra Singh

- **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

\

### Answer by Pushpendra Singh

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.\
\


---

Original Source: https://www.mindstick.com/interview/207/types-of-join

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.