Try doing something along the lines of this:
SELECT
max(ml_id) as ml_id,
max(ml_firstname) as ml_firstname,
max(ml_lastname) as ml_lastname,
max(other) as other,
ml_email
FROM nl_mailgroups
WHERE ml_id = 0
OR EXISTS
(
SELECT 1
FROM nl_catREL
WHERE nl_catREL.groups_id = <cfqueryparam value="#form.sendGROUP#"
cfsqltype="cf_sql_integer"/>
AND (nl_catREL.ml_id = nl_mailgroups.ml_id)
)
GROUP BY ml_email
ORDER BY 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:319706
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
