优化not in 查询不包含

insert into #tocreate select cc.OUID,cc.FNUMBER,cc.FNAME,cc.FMODEL,cc.FUNIT,cc.ISKEY from (select CRM_ICITEM.*,New_materielsExtensionBase.new_fnumber as tempcolum from CRM_ICITEM left join New_materielsExtensionBase on CRM_ICITEM.fnumber=New_materielsExtensionBase.new_fnumber) as cc where cc.tempcolum is null