Bruce Sorge wrote: > When I run this query: > > UPDATE tblCouncilEmailGroup > SET MemberID = > (SELECT Member_ID > FROM tblCurrentCouncilMembers > WHERE tblCouncilEmailGroup.DONEID = (tblCurrentCouncilMembers.DONE_ID)) > > I get the message: > > Subquery returned more than 1 value. This is not permitted when the subquery > follows =, !=, <, <= , >, >= or when the subquery is used as an expression. > The statement has been terminated. > > I tried using the IN operator and still no go. Any ideas? > > Thanks, >
It looks like you might be trying to update tblCouncilEmailGroup so that it has the same MemberID as tblCurrentCouncilMembers where the DONEID's are equal...this query should do that... UPDATE tblCouncilEmailGroup SET tblCouncilEmailGroup.MemberID = tblCurrentCouncilMembers.Member_ID FROM tblCouncilEmailGroup INNER JOIN tblCurrentCouncilMembers ON tblCouncilEmailGroup.DONEID = tblCurrentCouncilMembers.DONE_ID ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2795 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
