Joins in Sql

Joins in Sql can be classified as below:-

1) Inner Join:-Inner join return all the matching record between two table.

For e.g.

2.1) Left Outer Join:-Left outer join returns all the matching record between 2 table plus non matching record from left table.

For e.g.

2.2) Right Outer Join:-Right outer join returns all the matching record between 2 table plus non matching record from right table.

For e.g.

2.3) Full Join:-Full outer join returns all the matching record from both the table plus non matching record from both the tables.

For e.g.

3) Cross Join:-Cross join produces the Cartesian product of the 2 tables that are involved in the join operation.

For e.g.