这样的语句有什么问题吗?SQL codeinsert into AutoAccTemp (brid, lb,bz) select a.id,1,from mzsf..m
这样的语句有什么问题吗?
SQL code
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