SQL Join types explained with 1 picture

Venn diagrams are often over-used, however in this scenario it is a truly perfect fit for explaining SQL Joins.

If you ever wonder how a join works or which join you should use, take a look at this picture:

SQL Joins

 

[important]Credits to CL Moffatt for creating this picture: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins[/important]

Share
  • ZerCon

    right on the image is CL Moffatt