|
allan8964
Posting Yak Master
202 Posts |
 Posted - 06/07/2012 : 13:24:00
|
Hi there,
When I run code as below:
update table1
set col1 = 'TEST'
where col2 = 'DEMO'
I got error msg as "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."
subquesry as Where clause should return more than one value here, why did I get the error? I have no problem to run this same code to other tables. What should I check? Thanks in advance. |
|
'Subquery returned more than 1 value' error
