SQL Join

Jun 15

Written By Bear

A SQL JOIN combines records from two tables.

A JOIN locates related column values in the two tables using key-values.

A query can contain one or multiple combinations of JOIN operations.

Types of JOINS:

INNER JOIN: Returns all rows when there is at least one match in BOTH tables.

LEFT JOIN: Return all rows from the LEFT table, and the matched rows from the right table.

RIGHT JOIN: Return all rows from the RIGHT table, and the matched rows from the left table.

FULL JOIN: Combines the results of both Left and Right outer joins.

SQL Tutorial

Featured

Select Statement

Aliases

Select Distinct

Select TOP

Select MIN MAX

Where Clause

Where IN

Where LIKE

Where Between

Group By

Order By

Having

SQL Join

Inner Join

Left Join

Right Join

Full Join

Case Statement

Bear