JOIN clause combine rows from two or more tables, based on a common field between them.

There are five types of JOIN, defined by ANSI standard SQL–

Sr.	JOIN TYPES	USAGE
1	INNER JOIN	Returns records that have matching values in both tables
2	LEFT OUTER JOIN	Returns all records from left table and matching records from right table
3	RIGHT OUTER JOIN	Returns all records from right table, and matching records from the left table
4	FULL OUTER JOIN	Returns all records when there is a match in either left or right table
5	CROSS JOIN	Returns combinations of each row of the first table with the each row from second table.

Syntax for INNER JOIN,LEFT JOIN,RIGHT JOIN,FULL OUTER JOIN-

SELECT <column_name(s)>

FROM <table1>

[INNER JOIN|LEFT JOIN|RIGHT JOIN|FULL OUTER JOIN]<table2>

ON <table1.column_name=table2.column_name>

WHERE<condition>;

Syntax for CROSS JOIN-

SELECT <column_name(s)>

FROM <table1>

CROSS JOIN<table2>;