Retrieve Data from Multiple Tables with INNER JOIN

SELECT 
    orders.order_id, 
    users.username, 
    products.product_name, 
    order_items.quantity, 
    order_items.price 
FROM 
    orders
INNER JOIN 
    users ON orders.user_id = users.user_id
INNER JOIN 
    order_items ON orders.order_id = order_items.order_id
INNER JOIN 
    products ON order_items.product_id = products.product_id
WHERE 
    orders.order_date >= '2023-01-01';

How it works: This snippet illustrates how to use INNER JOIN to combine data from multiple tables. It links `orders` with `users`, `order_items`, and `products` based on their respective foreign key relationships (e.g., `user_id`, `order_id`, `product_id`). This allows web developers to retrieve a unified set of information from normalized database schemas, such as fetching order details along with customer and product information.