Thanks Barney! The JOIN and GROUP clause might be over my head.
Do I use a RecordCount? Barry >You just need a JOIN and GROUP BY clause. Check out the >subquery-to-join docs on MySQL's site. They have examples of how to do >exactly what you want. > >cheers, >barneyb ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4