Explain, SQL, Joins, Inner Join, Outer Join, Left Outer Join, Right Outer Join, Differences, Comparison.

Explain different types of JOINS in SQL ?

The following are the JOINS in SQL

. INNER JOIN
. OUTER JOIN
>> LEFT OUTER JOIN
>> RIGHT OUTER JOIN
>> FULL OUTER JOIN


Inner Join:

This will give results by selecting matching rows between two tables.

Left Outer Join:

This will give results by selecting matching rows from both the tables plus all the rows from left table.

Right Outer Join:

This will give results by selecting matching rows from both the tables plus all the rows from right table.

Full Outer Join:

This will give all the rows from both the tables.