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

阿拴

我不知道为什么我会收到此错误：-
5 c" D4 A7 m: ?& I  rSubquery 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.
* T" g3 o. ]! j  S0 b+ B" K. I/ }我正在尝试运行此查询：
ALTER TABLE Test1 NOCHECK CONSTRAINT ALL
' D" Y: F# h: U; HALTER TABLE Test2 NOCHECK CONSTRAINT ALL

UPDATE Test1
& }  I7 i7 n/ z( `8 M% kSET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45'
$ d0 w2 @! c2 c1 x4 DWHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45';
# }2 H1 A; U  f/ g% }+ gUPDATE Test2
" s# w+ y6 c4 @4 XSET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,
8 {8 n+ {/ V9 i6 m0 R2 OSpecID = NULL ,
RefLastName = 'Dummy' ,
RefFirstName = 'First Name' ,
! j% D  Y/ s: URefMiddleName = NULL ,
RefPhone1 = '111444444' ,
" i' q, c* @7 p) {3 e9 yRefPhone2 = '2121222' ,
3 z+ O/ s% O& l$ i0 gRefFax = '222222' ,
RefEmail = 'xxxxxxx@hotmail.ca'
WHERE
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'
ALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL
$ A" @0 w3 t! ^! I' VALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
               
. o, v: c3 @8 k/ j解决方案: