Inner Join- Pulls together what they have in common.

NotInner Join- bring two fields together but excluding the similarities.

Left Only Join- Pulls everything from the left table with any similarities from the right table and excludes any unique data that is from the right table.

Right Only Join- Pulls everything from the right table with any similarities from the left table and excludes any unique data that is from the left table.

Full Join- Pulls everything from both tables into a single table.