i believe the correct function to use is IFNULL(), not ISNULL()... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/
Jason Fisher wrote: > 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:316311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
