Msg#: 4534413 posted 3:42 pm on Jan 9, 2013 (gmt 0)
Yea, it's basically just so I can tally total amount of stock by manufacturer. So if there are two manufacturers, Acme and WidgetCo, I'd like it loop through and return the total sum of prod_qty where prod_man = man_id
Acme: 49 unique products (246 items in stock) WidgetCo: 26 unique products (421 items in stock)
Or something like that. We're tracking t-shirt transfers so we don't want to enter each individual transfer (and amount of each transfer in stock) as inventory, we'd rather just keep track of how many transfers we have, in total, by manufacturer.
Msg#: 4534413 posted 4:00 pm on Jan 9, 2013 (gmt 0)
That's amazing. I just can't seem to wrap my head around joins and my code is about four times longer and uglier than it needs to be because of that. That is exactly what I needed. Thank you so much coopster, I really appreciate your help!