[MySQL] JOIN clause

Rex Chiang

·

Follow

Jan 24, 2022

--

Listen

Share

Tables for Examples

INNER JOIN

• MySQL JOIN is equal to INNER JOIN.

LEFT JOIN

RIGHT JOIN

FULL JOIN

• MySQL doesn’t support FULL JOIN.
• We can use UNION to combine LEFT JOIN and RIGHT JOIN.