I'm getting a Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression eeror when running an update statement.
it's pretty basic and does not contain a subquery:
UPDATE IDO SET IDO.PARTNO = 'MIS56265' WHERE IDO.PARTNO = '047-000009-0001'
UPDATE IDO SET IDO.PARTNO = 'MIS56266' WHERE IDO.PARTNO = '047-000013-0000'
any suggestions are appreciated.