I have this update statement and I am sure there has to be a way to make it more efficient. It currently works but I would like to find a way to do it with only 1 select statement rather than 2. Is this possible?
UPDATE KELLYP.LOSTSALE A
SET A.UNFMT = (SELECT SUNFMT FROM KELLYP.INSMFHTEST B
WHERE A.LSPART = B.SPART AND A.LSLNCD = B.SFRAN)
where exists (select sunfmt
from kellyp.insmfhtest b
where a.lspart = b.spart and a.lslncd = b.sfran);