So I'm trying to do a simple update to a table, here's the code:
set REGION = '0382'
where CITY = '9382'
Simple as that. Some already have the REGION set to 0382, some are blank, just want to fill in the blank ones (or correct any potentially incorrect records).
I'm getting the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I'm I going about this the wrong way?