on 6/16/03 8:42 AM, Jochem van Dieten at [EMAIL PROTECTED] wrote: > Jeff wrote: > >> I'm doing a fairly complex join, and the recordcount of that join is a >> different number than I actually need because I group the output. For >> instance, I might have a recordcount of 13, but since the output is grouped >> around, say, PropertyID, what you really see, are 2 properties. One with 7 >> rates, and one with 8 rates, from the join. >> >> This means that my query returns 8 PropertyIDs from one property, and 7 >> PropertyIDs from another property. What I'd like to do, is somehow come up >> with the count of unique propertyIDs from the query results. I thought, >> rather than run another query to get count and have two queries, I'd rather >> try to use the existing query and determine the count of unique PropertyIDs >> from the single, correct query. > > How about doing a QofQ: > SELECT DISTINCT PropertyID > FROM single_correct_query
And Craig too..."dayaaaaammmmm"... So simple. Why didn't I think of that? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
