I'm pretty sure I will smack my head when I hear the answer, but I'll ask anyway...
I am using a select count() query to get the number of people directly sponsored by a person... this works fine, the problem is that I only want to have the query count people that meet a certain qualification. There has to be a simple way to do this, my query pretty much looks like this: SELECT COUNT(node.name) FROM tbl1 as node, tbl1 as parent WHERE parent.sponsor=node.name AND node.paid='yes' GROUP BY node.name the "AND node.paid='yes'" seems to be doing nothing... I'm pretty sure I'm missing something really simple, help! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:307630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
