SQL Joins Visualizer

                    SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.a_id
                

Table A (Left) id, name

Table B (Right) id, a_id, role

Result Dataset

A.id	A.name	B.id	B.a_id	B.role

Load Preset Scenario

Select a preset to populate the tables with sample data suitable for learning.

Explanation

This tool runs a client-side simulation of SQL joins.
Table A is the 'Left' table.
Table B is the 'Right' table.
The join condition is TableA.id = TableB.a_id (or equivalent 2nd column of B).