Posts Tagged with "joins"

Visual Representation of SQL Joins on a graphical diagram

Posted by Stanislav Furman on February 18, 2012

For some programmers (especially for begginers) it might be a bit difficult to understand how do SQL joins work in real life. In fact, sometimes even experienced software developers are not able to explain what is the difference between JOINLEFT JOIN and RIGHT JOIN.

Luckily, I found, perhaps, one of the best visual representations of SQL joins I have ever seen which will definately help to understand the mechanism of SQL joins.

Visual Representation of SQL Joins, graphic diagram


See more graphical diagrams and explanations here