Database & SQL
SQL Join Type Reference
Search SQL join types by name or use case. Covers INNER, LEFT, RIGHT, FULL, CROSS, LATERAL joins plus anti-join and semi-join patterns with plain-English explanations.
Calculations run locally in your browserTool
About this tool
SQL Join Type Reference
The SQL Join Type Reference covers all standard SQL join types plus LATERAL, anti-join, semi-join, and join order planning with plain-English explanations and use cases.
• Look up the correct join type for an 'all rows with no match' query
• Understand when to use LATERAL vs a correlated subquery
• Find the Cartesian product join syntax for generating test data
• Reference anti-join pattern using LEFT JOIN WHERE IS NULL
Affiliate disclosure
Developer-friendly cloud infrastructure. DigitalOcean provides cloud compute, networking, and managed databases with predictable pricing.
Host databases on DigitalOcean
External site · Independent provider · We may receive a commission · Not a recommendation
FAQ
What does this tool tell you?
The SQL Join Type Reference covers all standard SQL join types plus LATERAL, anti-join, semi-join, and join order planning with plain-English explanations and use cases.
What affects the result most?
INNER JOIN: only rows with matching keys in both tables — most common join type. LEFT JOIN: all rows from left table, NULL for right columns when no match. CROSS JOIN: Cartesian product — every row in left × every row in right.
How should I use the result?
Use this tool to orient quickly to the concepts, field names, or values you are about to look up in a full specification or vendor documentation. It summarizes the common cases; the authoritative source remains whichever standard or vendor doc defines the values themselves.
Related tools