SQL
Perform Multi-Table JOINs in SQL
Master INNER, LEFT, and RIGHT JOINs to combine data from multiple related tables efficiently, retrieving comprehensive datasets for your web app.
SELECT
o.order_id,
u.username,
p.product_name,
oi.quantity,
oi.price_at_order
FROM orders o
INNER JOIN users u ON o.user_id = u.id
LEFT JOIN order_items oi ON o.order_id = oi.order_id
LEFT JOIN products p ON oi.product_id = p.product_id
WHERE o.order_date >= '2023-01-01'
ORDER BY o.order_date DESC;
How it works: This snippet demonstrates combining data from multiple tables using `JOIN` operations. It uses an `INNER JOIN` to link orders to users (ensuring an order must have a user) and `LEFT JOIN`s to bring in order items and product details. `LEFT JOIN` ensures that all orders are returned, even if they don't have associated order items or products yet. This is a core technique for retrieving related data for display in complex web interfaces like order history or user profiles.