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=89.70.4
