SELECT & JOINs
INNER JOIN
SELECT u.name, o.total FROM users u
INNER JOIN orders o ON u.id = o.user_id;
LEFT JOIN
SELECT u.name, o.id FROM users u
LEFT JOIN orders o ON u.id = o.user_id;
Quick reference for SELECT, JOINs, GROUP BY, indexes, and aggregation functions.
SELECT u.name, o.total FROM users u
INNER JOIN orders o ON u.id = o.user_id;
SELECT u.name, o.id FROM users u
LEFT JOIN orders o ON u.id = o.user_id;