How could a value be equal to two things at once? Your where clause requires that the gt.grouptype column simultaneously equal 'College' and 'Jewish'.
That query will return no results. ~Brad -----Original Message----- From: Nicholas Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:50 AM To: CF-Talk Subject: Re: Need query help 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:300429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
