INNER JOIN - only gets the value that happened to be in both table
LEFT JOIN- get all the value from the table 1( from TABLE)
RIGHT JOIN - get all the value from the joining table (JOIN TABLE)
full join/ outer join - get all the value from both table

UNION removes duplicates, whereas UNION ALL does not.