JOIN Visualizer
Click on each type of join to see how they create different results from the Users and Likes tables
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Description »
Hide description »
{{ sql[current_join].desc }}
Users
ID
Name
{{user.id}}
X
{{user.name}}
Add
Likes
User ID
Like
{{ like.user_id }}
X
{{ like.like }}
Add
JOIN Results
Name
Like
{{ join.name }}
{{ join.like }}
Hover over the Users or Likes tables to add or remove rows
Add