Re: aggregate query problems

OK, I wonder if it's the * in COUNT(*) ... try this:

SELECT tbl_member_language_group.language_group_name,
        COUNT(tbl_demographics.contact_id) AS CountOfcontact_id,
        tbl_demographics.town,
        tbl_demographics.region
FROM tbl_member_language_group LEFT JOIN
        tbl_demographics ON tbl_member_language_group.language_group_name = tbl_demographics.language_group
GROUP BY tbl_demographics.town, tbl_demographics.region, tbl_member_language_group.language_group_name
ORDER BY tbl_demographics.town, tbl_member_language_group.language_group_name

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:324275
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4