What is the difference between “INNER JOIN” and “OUTER JOIN”?

Rajanikant Hawaldar

2.5k

What is the difference between “INNER JOIN” and “OUTER JOIN”?

It is used to get matching Data between two or more tables based on “ON” or “WHERE” condition. Only matching rows are returned.

Outer joins are joins that return matched values and unmatched values from either or both tables

Inner Join
It is used to get matching Data between two or more tables based on “ON” or “WHERE” condition. Only matching rows are returned

Outer Join
It is used to get matching data from one table and all data form other.