是什么导致“ ubquery返回的值超过1个”错误？

阿拴

我不知道为什么我会收到此错误：-
$ N9 }1 h8 x$ mSubquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
' W& E$ B2 O- K& _5 w% U9 UThe statement has been terminated.
" n" ?0 H4 `7 a; Z- F$ O我正在尝试运行此查询：
ALTER TABLE Test1 NOCHECK CONSTRAINT ALL
ALTER TABLE Test2 NOCHECK CONSTRAINT ALL
4 y' _* M7 n2 U% ?2 H
UPDATE Test1
2 I: ]8 c0 X' W  iSET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45'
WHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45';
UPDATE Test2
SET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,
SpecID = NULL ,
RefLastName = 'Dummy' ,
RefFirstName = 'First Name' ,
2 E! r2 P( B- cRefMiddleName = NULL ,
: r$ }* l" {! y7 b" vRefPhone1 = '111444444' ,
RefPhone2 = '2121222' ,
6 ]% B3 N; l, `8 F7 aRefFax = '222222' ,
RefEmail = 'xxxxxxx@hotmail.ca'
# T0 ~! U9 E. X0 ]0 @3 ^- i# sWHERE
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'
# H) k2 n: ?. Y0 h8 L( t2 Q9 _! qALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL
ALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
% C/ {& Q0 w9 k4 `5 c# e               
$ x' x* F' |" q. l: d1 T解决方案: