Great, seems to work, except that it only returns records for items that have been ordered. Those products that have no associated orders do not show in the results. Is there a change that would get these other records to show up?
-- Edit --
Actually, it works perfectly, I just had a typo in the Group By. Thanks for the help!
|