2021-06-08
sql中存在not exists执行很慢、select * from View_CG_ChengQingIf where 1=1 and projectjiaoyitype='Z' and AuditStatus='3' and BiaoDuanGuid in (SELECT BiaoDuanGuid FROM CG_BiaoDuanInfo WHERE isnull(IsZuoFei,'0')!='1' AND isnull(IsLiuBiao,'0')!='1')and Not exist
原创
2021-06-08 09:48:44 ·
195 阅读 ·
0 评论