At a glance this looks wrong "tblCurrentCouncilMembers.Member_ID = NC_MC.DONE_ID"
Unless Member_ID is truly = to DONE_ID at which point I would rename the "NC_MC.DONE_ID" to "NC_MC.Member_ID" ----hope this helps SELECT tblCurrentCouncilMembers.Member_ID FROM tblCurrentCouncilMembers INNER JOIN NC_MC ON tblCurrentCouncilMembers.Member_ID = NC_MC.DONE_ID WHERE (NC_MC.PUBLICPHONE = 2 returns one record. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2832 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
