11 oct 2007 a visual explanation of sql joins. As shown in the venn diagram we need to matched rows of all tables. There are four basic types of sql joins.