SQL JOINs Explained: INNER, LEFT, RIGHT, FULL & CROSS
SQL JOIN types with visual examples: INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF joins. With real queries.
JOIN Types
-- INNER JOIN: only matching rows\nSELECT * FROM users u\nINNER JOIN orders o ON u.id = o.user_id;\n\n-- LEFT JOIN: all from left + matching right\nSELECT * FROM users u\nLEFT JOIN orders o ON u.id = o.user_id;\n\n-- RIGHT JOIN: all from right + matching left\n-- FULL OUTER JOIN: all from both\n-- CROSS JOIN: every combination (cartesian product)Try It Free
Use our free online tool — 100% client-side, no data leaves your browser.
Open SQL Formatter