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.