I
n
f
i
n
i
t
e
E
d
u
c
a
t
i
o
n
Search on site
Search on site
I
n
f
i
n
i
t
e
E
d
u
c
a
t
i
o
n
Edit
»
Login
Article
SQL | Join (Inner, Left, Right and Full Joins)
Skills that you will get in this material
JOIN
External link:
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all possible logical relations between data sets.