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.