---
title: "What are different Types of Join?"  
description: "What are different Types of Join?"  
author: "Odilian Gosselin"  
published: 2017-11-20  
canonical: https://answers.mindstick.com/qa/30984/what-are-different-types-of-join  
category: "technology"  
tags: ["database programming", "database"]  
reading_time: 2 minutes  

---

# What are different Types of Join?

What are different Types of [Join](https://www.mindstick.com/articles/35/join-in-sql-server)?

## Answers

### Answer by akriti kashyap

## Understanding what a JOIN is...

Combining two or more tables according to the terms mentioned in the table is possible because of the JOIN clause.

*There are several types of JOIN that are mentioned:* *\*

- Inner JOIN
- Left (Outer) JOIN
- Right (Outer) JOIN
- Full (Outer) JOIN

\

Learning about these terms in details…\
**Let us seek more about them...****\****Inner JOIN:** It selects those values whose entry are common in tables using INNER JOIN keyword![What are different Types of Join?](https://answers.mindstick.com/questionanswer/90bd5a7d-d0b1-4128-947b-41d4719b09eb/images/6cfa755b-03aa-4393-a8a4-8604fbb12837.png)\
\
**Left (Outer) JOIN:** It returns all the values present in Table 1 with the Table 2. It displays NULL value if nothing matches Table 2.![What are different Types of Join?](https://answers.mindstick.com/questionanswer/90bd5a7d-d0b1-4128-947b-41d4719b09eb/images/779705ce-b1d7-4acd-9ca9-6b1a12314500.png)\
\
**Right (Outer) JOIN:** It returns all the values present in Table 2 with the Table 1. It displays NULL value if nothing matches Table 1.![What are different Types of Join?](https://answers.mindstick.com/questionanswer/90bd5a7d-d0b1-4128-947b-41d4719b09eb/images/5df6edc2-ebb5-4561-88ef-2bda4a6f6751.png)\
\
**Full (Outer) JOIN:** Either of the matches in Table 1 or Table 2 is been returned as records. It is considered to as the large data-set.![What are different Types of Join?](https://answers.mindstick.com/questionanswer/90bd5a7d-d0b1-4128-947b-41d4719b09eb/images/882c3935-e705-4255-8ea0-b15922ddc6fe.png)\
\
*Hope you enjoyed learning…*\
**All The Best!**\


---

Original Source: https://answers.mindstick.com/qa/30984/what-are-different-types-of-join

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