insert into AutoAccTemp (brid, lb,bz)
select a.id,'1',''
from mzsf..mzbr a
left join mzsf..mzcard b on a.cardno=b.cardno
left join AutoAccTemp c on a.id=c.brid
where b.lb='1' and c.brid is null
查询AutoAccTemp 符合条件的再插入AutoAccTemp ,40万条数据,问题不大吧
...全文
797打赏收藏
这样的语句有什么问题吗?
insert into AutoAccTemp (brid, lb,bz) select a.id,'1','' from mzsf..mzbr a left join mzsf..mzcard b on a.cardno=b.cardno left join AutoAccTemp c on a.id=c.brid where b.lb='1' and c.brid is null 查询AutoAccTemp 符合条件的再插入AutoAccTemp ,40万条数据,问题不大吧