Mastering Table Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN)

 

Joins allow you to combine records from two or more tables based on a shared foreign key relationship.

SQL

-- Fetch all users alongside their orders (even if they have none)
SELECT users.username, orders.order_date, orders.total_amount
FROM users
LEFT JOIN orders ON users.id = orders.user_id;