SQL JOIN Types

Table join operations — INNER, LEFT, RIGHT, FULL, CROSS, SELF JOIN. This category documents 28 SQL join types entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN, NATURAL JOIN, LATERAL JOIN, IMPLICIT JOIN / Comma Join, SEMI JOIN, ANTI JOIN, CROSS APPLY / OUTER APPLY, EQUI JOIN / Non-EQUI JOIN, Theta Join / Natural Join, Hash Join / Merge Join (Physical), UNION vs JOIN Visual, LEFT JOIN with NULL Filtering, Self-Join for Hierarchies, INNER JOIN vs LEFT JOIN Performance, LATERAL JOIN (PostgreSQL/ SQL Server), Recursive JOIN (Connect By), Hash Join (Optimizer Strategy), RIGHT JOIN with NULL Filter, FULL JOIN with Filter, CROSS JOIN with WHERE (Implicit Join), MERGE JOIN (Physical Operator), HASH JOIN Concept (Detailed), LATERAL JOIN in PostgreSQL. Not sure where to start? INNER JOIN and LEFT JOIN are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.