Mental Model For SQL Joins

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 ...