Portable SQL/Statements/Data retrieval/Join syntax

SQL supports several ways to join the rows of two or more tables.

Inner join

SELECT column-list
FROM table1
[INNER] JOIN table2 ON table1.key = table2.key
WHERE conditions

Left join

SELECT column-list
FROM table1
LEFT JOIN table2 ON table1.key = table2.key
WHERE conditions

---

Back to Overview