Display each customer’s complete order. This will show a
separate line for each item in each order per customer. Sort by
customer_id, order_id, and item_id.
Display customer_id, customer name, customer order_id, sales
order_date, sales ship_date, item_id, product_id, product
description, item actual_price, item quantity, calculate line item
total.
This is a join of tables customer, sales, item, and product.

table customer (customer_id, name, address, city, state, zip_code, area_code, phone_number, salesperson_id, credit_limit, comment)

table item (order_id, item_id, product_id, actual_price, quantity, total)

table product (product_id, description)

table sales (salesperson_id, customer_id, customer, product_id, product, amount)

I'm kind of confused, because I'm not exactly sure what to write for the WHERE statement for this.

I NEED MAJOR HELP!!!!