Deviopath › PostgreSQL

Who Placed Each Order?

Easy · Joins

JOIN ... ON combines rows from two tables where the condition matches. Here orders.customer_id points to customers.id. Short table aliases (orders o) keep the query readable.

Return order_id (the order id), customer (the customer name) and total, one row per order.

Next: Add a Product