There are lots of nice diagrams explaining the difference between the different joins in SQL.
References
- Code Project for those who Code - Visual Representation of SQL Joins
- https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
