Re: aggregate query problems

Hi Jason

updated query here (I'm using access at the moment)

SELECT tbl_member_language_group.language_group_name, Count(*) 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:324271
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4