Originally Posted by wige

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!