SQL JOIN
A JOIN combines rows from two tables that share a value. INNER JOIN keeps rows that match in both tables.
Try it yourself
Loading editor…
orders.user_id points to users.id — that shared value is how the two tables link.
A JOIN combines rows from two tables that share a value. INNER JOIN keeps rows that match in both tables.
Loading editor…