I have a table iminvloc that will have multiple records for one item_no.
item_no loc QtySold ReOrder
ABC 1 100 40
ABC 2 200 55
ABC 3 400 2
What I want to do is sum the qtysold for all locations but only pull the ReOrder from location 1.
select item_no, sum(qtySold) as Total sold, (Reorder from location 1??
I would want my results to be:
ABC 700 40