SQL Joins Clause

The SQL JOIN clause used to combines OR join rows from two or more tables. The JOIN clause creates a set of rows in a temporary table.

SQL JOIN's Syntax

SELECT Table_1.T1Column_1, Table_2.T2Column_1
FROM Table_1
INNER JOIN Table_2 ON Table_1.T2Column_2=Table_2;

Different Types of JOIN's in SQL

Four basic types of SQL JOIN's:

• INNER JOIN
• LEFT JOIN or LEFT OUTER JOIN
• RIGHT JOIN or RIGHT OUTER JOIN
• FULL JOIN or FULL OUTER JOIN

See below-mentioned image for more understanding

EQUI JOIN

The SQL EQUI JOIN is a simple SQL JOIN used to the equal sign (=) as the comparison operator for the condition.

• QL OUTER JOIN and SQL INNER JOIN both are the EQUI JOIN.

NON EQUI JOIN

The SQL NON EQUI JOIN is a JOIN used to the comparison operator other than the equal sign like >, <, >=, <= with the condition.