Is what I am trying to do possible, and if it is, what am I doing wrong? This query: ----------- select ptssn, sum(arbalancedue) as sumar from ga_temp group by ptssn having sum(arbalancedue) < 50
Yields these results: --------------------- Ptssn sumAr 237451046 26.4800 255785250 25.2000 267582694 42.3200 294629611 42.3200 But what I really want is 1 query to return to me a count of 4 with a total of 136.32 This query returns no results: ------------------------------ select count(distinct ptssn), sum(arbalancedue) as sumar from ga_temp having sum(arbalancedue) < 50 Thanks, Dan ------------ Dan O'Keefe 954-501-3115 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
