Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- scs_customer.customer_name AS customer,
- scs_item.item_name AS item,
- scs_order.item_ammount AS quantity,
- scs_order.order_status AS status,
- scs_order.placed_by AS owner,
- scs_order.date_placed
- FROM
- scs_order
- join scs_item
- on scs_order.item_id=scs_item.item_id
- join scs_customer
- on scs_order.customer_id=scs_customer.customer_id
- ORDER BY scs_customer.customer_name ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement