Thanks all of you. Wow, I really enjoy this list when you all pitch in and help each other like you just did.
Really Appreciate it. Terry -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Sunday, December 03, 2006 8:20 AM To: CF-Talk Subject: Re: Sql aggregate woes Jim Wright wrote: > SELECT inventory.ItemNumber, SUM(inventory.qty) as invqty FROM > inventory GROUP BY inventory.ItemNumber HAVING SUM(inventory.qty) > 0 > oops...told you to take the DISTINCT out, and then left it in...see above. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4