---
title: "How the Inner Join in SQL is different from that of Outer Join?"  
description: "How the Inner Join in SQL is different from that of Outer Join?"  
author: "Anonymous User"  
published: 2019-09-12  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/33600/how-the-inner-join-in-sql-is-different-from-that-of-outer-join  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# How the Inner Join in SQL is different from that of Outer Join?

The **Inner join** is the one that is useful for the purpose of returning the rows provided at least two tables are met critically. But, the **outer join** is the one that is useful for returning the value of rows and tables that generally include the records that must be same in all the tables.

## Answers

### Answer by Anonymous User

The **Inner join** is the one that is useful for the purpose of returning the rows provided at least two tables are met critically. But, the **outer join** is the one that is useful for returning the value of rows and tables that generally include the records that must be same in all the tables.


---

Original Source: https://www.mindstick.com/interview/33600/how-the-inner-join-in-sql-is-different-from-that-of-outer-join

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