【无标题】sql随记

update T_ADS_SRV_FLGL_02 t set t.EVALUATE_TIME = (select REC_CREATE_TIME from T_ADS_SRV_FLGL_03 where EXCEPPT_ID=t.REC_ID order by REC_CREATE_TIME asc limit 1)

insert into T_ADS_SRV_FLGL_02_TEMP select * from T_ADS_SRV_FLGL_02

delete from T_ADS_SRV_FLGL_02_DEPT_TEMP t where t.DEPT_ID = (select EVALUATE_DEPT_ID from T_ADS_SRV_FLGL_03 where EXCEPPT_ID = t.EXCEPPT_ID)

insert into T_ADS_SRV_FLGL_02_DEPT_TEMP(EXCEPPT_ID, DEPT_ID) select (EXCEPPT_ID, EXCEPPT_DEPT_ID) from T_ADS_SRV_FLGL_03 where 1=1

delete from T_ADS_SRV_FLGL_02_DEPT_TEMP where (EXCEPPT_ID, DEPT_ID) in (select EXCEPPT_ID, DEPT_ID from T_ADS_SRV_FLGL_03);
//添加表备注
comment on table T_ADS_SRV_ZZGL_03 is '组织机构图管理表'