I have this query: UPDATE tblCurrentCouncilMembers SET Public_Phone = 2 WHERE Member_ID IN (SELECT tblDone.done_ID FROM tblDone INNER JOIN NC_MC ON tblDone.done_ID = NC_MC.DONE_ID WHERE (NC_MC.PUBLICPHONE = 2))
Problem is, I get 0 results. Member_ID in tblCurrentCouncilMembers has the exact same ID's as the DONE_ID field in tblDONE (tblDONE is going away soon). When I do a query joining the NC_MC table and tblDONE, I get several results, but when I join tblCurrentCouncilMember.Member_ID to NC_MC.DONE_ID, I get back one result. I am curious as to why that is. So this query: SELECT tblDone.done_ID FROM tblDone INNER JOIN NC_MC ON tblDone.done_ID = NC_MC.DONE_ID WHERE (NC_MC.PUBLICPHONE = 2 Returns several records. This query: 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. And like I said, if I do a query joining tblDONE and tblCurrentCouncilMembers, I get back over 6000 records. I am confused. Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2828 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
