Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2015
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT
  2. scs_customer.customer_name AS customer,
  3. scs_item.item_name AS item,
  4. scs_order.item_ammount AS quantity,
  5. scs_order.order_status AS status,
  6. scs_order.placed_by AS owner,
  7. scs_order.date_placed
  8. FROM
  9. scs_order
  10. join scs_item
  11. on scs_order.item_id=scs_item.item_id
  12. join scs_customer
  13. on scs_order.customer_id=scs_customer.customer_id
  14. ORDER BY scs_customer.customer_name ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement