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
...
acdev.hashnode.dev2 min read