Hard to say what is going on. The following works fine for me: SELECT node.userCity,count(node.userCity) FROM core.users AS node, core.users AS parent WHERE parent.userName = node.userFirstName AND node.userCity = 'Pasadena' GROUP BY node.userCity
I seem to get the correct number based on the node.userCity where clause. On Fri, Jun 20, 2008 at 4:23 PM, Jessica Kennedy <[EMAIL PROTECTED]> wrote: > no luck... > > I do need the group by clause, my actual query is much larger than the one > posted. the problem, for example is this: > > for five people, paid="no", for five others, paid="yes" under one parent > sponsor. > I am now getting a result of "10", but I need the result to be "5", only > counting those people under sponsor who have paid. > > what am I doing wrong?? =( > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4