>Michele, > >Could you provide an example of the statement, stripped down to what's >necessary to demonstrate the problem? > > -- Ken > >On 2/8/07, Michele Michele <[EMAIL PROTECTED]> wrote: Select tzs, enf_num, sum(A) as A, sum(B)as B, count(*) total From SomeT Where value in = A and several other conditions to group the data. I need a count of the values for Enf_num, and enf_num is not in the conditions. I don't know, this hunt and peck and guess sql stuff is not fun!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2723 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
