JOIN

Bir nechta jadval qatorlarini umumiy kalit bo‘yicha birlashtirish: INNER JOIN — ikkalasida bor, LEFT JOIN — chap jadvalning hammasi.

SELECT o.id, c.name FROM orders o JOIN customers c ON c.id = o.customer_id;