This should work and is much clearer that your original statement.
SELECT t.groupid,
t.groupimage,
t.groupname,
t.groupcity,
t.state,
t.voicingid,
t.groupcontactperson,
t.country,
t.region,
x.groupid,
x.grouptype,
gt.grouptype
FROM tblgroups t,
INNER JOIN tblgrouptypes gt ON gt.groupid = t.groupid,
INNER JOIN tblgrouptypes_x x ON x.grouptype = gt.grouptype
WHERE (gt.grouptype = 'College'
AND gt.grouptype = 'Jewish')
ORDER BY t.groupsortname
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
