Update statement getting error "Subquery returned more than 1 value"
Posted on 2007-03-22
Hello, I need to update a field in a table with data from another table and am getting an error. What's wrong with my statement?
set SOPNumber = (Select b.SOPNumber
from BB_OrderHeader b, #TempMyQuotes a
Where a.QuoteNumber = b.QuoteNumber)
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.