UPDATE `r_komponen` AS A
INNER JOIN r_soutput AS B ON CONCAT(A.kddept,".",A.kdgiat,".",A.kdoutput)=CONCAT(B.kddept,".",B.kdgiat,".",B.kdoutput)
SET A.soutputid=B.id, A.kddit=B.`kddit`,A.up_by="andra_200719"
WHERE A.cr_by LIKE "basedonRKA190719"