This should do it:
SELECT
max(nl_mailgroups.ml_id) as ml_id,
max(nl_mailgroups.ml_firstname) as ml_firstname,
max(nl_mailgroups.ml_lastname) as ml_lastname,
max(nl_mailgroups.other) as other,
nl_mailgroups.ml_email
FROM nl_mailgroups INNER JOIN
nl_catREL ON nl_mailgroups.ml_id = nl_catREL.ml_id
WHERE nl_catREL.groups_id = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#form.sendGROUP#" />
AND nl_catREL.ml_id IS NOT NULL
GROUP BY nl_mailgroups.ml_email
ORDER BY nl_mailgroups.ml_email
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
