Common Joins

-- Inner Join
SELECT *
FROM table1
INNER JOIN table2 ON table1.id = table2.id;

-- Left Join
SELECT *
FROM table1
LEFT JOIN table2 ON table1.id = table2.id;