Yes, it means that this: SELECT Member_ID FROM tblCurrentCouncilMembers WHERE tblCouncilEmailGroup.DONEID = (tblCurrentCouncilMembers.DONE_ID)
is selecting more than one value, which is not ok. You can only update with a single value. Btw, your query will update every row in tblCouncilEmailGroup with the same value the way it's currently written. On 3/24/07, Bruce Sorge <[EMAIL PROTECTED]> 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, > > -- > Bruce Sorge > > "I'm a mawg: half man, half dog. I'm my own best friend!" > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2790 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
