What is The Difference Between Inner and Outer Join? – POFTUT

What is The Difference Between Inner and Outer Join?

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join two tables with different magic.

Example Tables

In order to understand Inner and Outer Joins we will use following example tables with their data. We will use two tables those named Personels and Persons

Inner Join

If we inner join Persons with Personels we will get only intersection of the given fields. In this example we want to get the LastName column intersection in two tables Persons and Personels .

Right Outer Join

The right outer join will return all entries in left table and

LEARN MORE  How To List MySQL/MariaDB Databases

Left Outer Join

 

What is The Difference Between Inner and Outer Join? Infografic

What is The Difference Between Inner and Outer Join? Infografic

What is The Difference Between Inner and Outer Join? Infografic

Leave a Reply

Your email address will not be published. Required fields are marked *

Enjoy this blog? Please spread the word :)