What is the difference between “INNER JOIN” and “OUTER JOIN”?
Inner JoinIt is used to get matching Data between two or more tables based on “ON” or “WHERE” condition. Only matching rows are returned
Outer JoinIt is used to get matching data from one table and all data form other.