Inner Join- Pulls together what they have in common.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-175.png)
NotInner Join- bring two fields together but excluding the similarities.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-176.png)
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.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-177.png)
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.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-180.png)
Full Join- Pulls everything from both tables into a single table.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-179.png)