UPDATE T_RPT_REPORT T1
SET (T1.CLASSIFICATION, T1.IS_PUBLIC, T1.TRADE_UNIT) =
(SELECT T2.CLASSIFICATION, T2.IS_PUBLIC, T2.TRADE_UNIT
FROM T_RPT_JYS T2
WHERE T1.JYS_ID = T2.ID)
WHERE EXISTS (SELECT 1 FROM T_RPT_JYS T2 WHERE T1.JYS_ID = T2.ID);
UPDATE T_RPT_APPLICATIONS SET IS_DEL = 1 WHERE REMARK = '文件失效';