I’m trying to update ALL records returned from a subselect as below example. How can i do? Currently is errors saying more than one result is not allowed.
update FILE set (o1eutp , o1sgrp , o1sls# ) =
f4 , f6 , f5
from OTHERFILE x join FILE y on x.f2 = char(y.o1cst1) and x.f1 = char(y.o1ord# ) ) ;