CREATE TABLE TCPYY_CPCW_20191129 AS SELECT * FROM TCPYY WHERE CPID =36335;
CREATE TABLE TZJJZ_CPCW_20191129 AS SELECT * FROM TZJJZ WHERE CPYYID IN (SELECT ID FROM TCPYY WHERE CPID =36335);
SELECT * FROM TFP_CPSYJB WHERE CPID =36335–错误 A–38613 B-38614
SELECT * FROM TFP_CPSYJB WHERE CPID =36333–正确 A–38612 B-38611
UPDATE TCPYY C SET CPID=36333,XSXM= 3333,SYJB=(CASE WHEN C.SYJB=38613 THEN 38612 WHEN C.SYJB=38614 THEN 38611 END )/,CPQX/ WHERE CPID =36335;
delete FROM TZJJZ WHERE CPYYID IN (SELECT ID FROM TCPYY WHERE CPID =36333);
COMMIT;