判断要导入课程是否存在

来源:互联网 发布:网络应急演练记录 编辑:程序博客网 时间:2024/05/29 04:52
SELECT * FROM temp a WHERE not exists(SELECT 1 from kc b WHERE a.kcdm=b.kcdm and round(a.xf,1)=round(b.xf,1));

0 0