SQL Server 从一个表查询数据插入到另外一个表中
从一个表查询数据插入到另外一个表中
-- 插入数据
insert into a_linshibiao (xh,termcode,kcbh)
select cc.xh,cc.termcode,cc.kcbh
from py_cj cc left join xj on cc.xh=xj.xh
where (cc.termcode=36 or cc.termcode=37)
and (xj.nj =2019)
and (cc.xwbj=0 or isnull(cc.xwbj,'')=0)
select cc.xh,cc.termcode,cc.kcbh
from py_cj cc left join xj on cc.xh=xj.xh
where (cc.termcode=36 or cc.termcode=37)
and (xj.nj =2019)
and (cc.xwbj=0 or isnull(cc.xwbj,'')=0)
