I have to tables, products and manufacturers, that looks basically like this:
What I'm trying to do is output a list of available stock, by manufacturer, so something like:
"Manufacturer: $man_name | SUM($prod_qty) in stock"
So I'm trying to get the total sum of prod_qty (in stock product) for each associated prod_man (manufacturer id).
I'd like to show you what I have currently, but it's a gnarley nest of loops and queries that really does nothing but spout errors. Can anyone show me how to write a query like this?
Thanks in advance!