What is The Difference Between Inner and Outer Join?

RSS
FACEBOOK
FACEBOOK
PINTEREST
PINTEREST
LINKEDIN
INSTAGRAM

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  Backup and Restore MySQL Databases With Mysqldump In Linux

Left Outer Join

RSS
FACEBOOK
FACEBOOK
PINTEREST
PINTEREST
LINKEDIN
INSTAGRAM

Leave a Reply

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

Enjoy this blog? Please spread the word :)