Mental Model For SQL Joins
Jun 3, 2022 · 2 min read · SYNTAX SELECT * FROM table1 JOIN table2 ON table1.id = table2.id; Just replace JOIN with LEFT JOIN/ FULL OUTER JOIN, etc if using a different join. Join / Inner Join loop through each row in table1 for each row in table1, loop through table2 ...
Join discussion