子查询在sql中返回了超过1个值

Question

我有一个小的查询，当我运行它时，出现错误。请帮帮我。 查询：

update MozendaData set [Sub Device]= 
(select [Sub Device] from oldMozendaData 
    where MozendaData.[Product Details]=oldMozendaData.[Product Details]) 
where UserID ='APAC\gsvivekanand' 

Answer 1

试试这个：

UPDATE m 
SET m.[Sub Device] = o.[Sub Device] 
FROM MozendaData AS m 
INNER JOIN oldMozendaData AS o ON m.[Product Details] = o.[Product Details] 
WHERE m.UserID ='APAC\gsvivekanand';