Visual JOIN Understand how joins work by interacting and see it visually

INNER JOIN

(or JOIN)

LEFT JOIN

 

RIGHT JOIN

 

OUTER JOIN

(with UNION)
Description » Hide description » {{ sql[current_join].desc }}

Users

ID Name
{{user.id}} {{user.name}}

JOIN

Name
{{ join.name }} {{ join.like }}

Likes

User ID
{{ like.user_id }} {{ like.like }}