Problem with multi-table MySQL query
- by mahle
I have 3 tables. Here is the relevant information needed for each.
items
prod_id
order_id
item_qty
orders
order_id
order_date
order_status
acct_id
accounts
acct_id
is_wholesale
items is linked to order by the order_id and orders is linked to accounts via acct_id
I need to sum item_qty for all items where prod_id=464 and the order stats is…