UPDATE rskpcfceditlog SET rskpcfceditlog.pcfcbankref = (SELECT rskpcfc.pcfcbankref FROM rskpcfc WHERE rskpcfc.pcfcid = rskpcfceditlog.pcfcid) rskpcfceditlog.actype = (SELECT rskpcfc.pcfcbankref,rskpcfc.actype FROM rskpcfc WHERE rskpcfc.pcfcid = rskpcfceditlog.pcfcid) WHERE EXISTS (SELECT rskpcfc.pcfcbankref,rskpcfc.actype FROM rskpcfc WHERE rskpcfc.pcfcid = rskpcfceditlog.pcfcid and rskpcfceditlog.pcfcid=@cond1);
UPDATE rskpcfceditlog SET pcfcbankref = rskpcfc.pcfcbankref, actype = rskpcfc.actype --, add more columns here FROM rskpcfceditlog JOIN rskpcfc ON rskpcfc.pcfcid = rskpcfceditlog.pcfcid WHERE rskpcfceditlog.pcfcid = @cond1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)