didn't work, got an error. changed the isnull to ifnull, got a "invalid use of a group function" error... I don't even know how to fix that...=(
> Try this, I think it's what you're looking for: > > SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points, p. > short_description, p.quantity, p.image > FROM tblproducts as p LEFT JOIN > tblorder_list as o ON p.sku = o.sku #can_afford# > WHERE SUM(ISNULL(o.qty, 0)) < p.quantity > GROUP BY p.sku ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4