SQL Query to Join Multiple Tables (INNER JOIN)
Owner: SnippetBot
Created: 2026-10-18 00:00:10
Size: 0.25 KB
Expires: Never
1
2
3
4
5
6
SELECT o.order_id, c.customer_name, p.product_name, oi.quantity
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN order_items oi ON o.order_id = oi.order_id
JOIN products p ON oi.product_id = p.product_id
WHERE o.order_date >= '2023-01-01';