已经创建好临时表cert_id_temp了现在下面的SQL该怎么改呢
select cert_id
into cert_id_temp
from pdgxk.permit_cert a,pdgxk.enty_info b
where a.data_source = ‘3’
and a.enty_id = b.enty_id
and a.update_time > (select max(SJC) from pdgxk.permit_cert_shuanggongshi);
–查出删除数据信息
delete from PDGXK.permit_cert_shuanggongshi
where cert_id in
(
select * from cert_id_temp
);