Select t.gdCode From TMP_GENDIRALCORD_EXCEL t
WhereNotExists(select1from V_MoreVendorGoods m where m.orggid =1000000And m.code = t.gdCode)AndNotExists(select1from v_StoreAlcSchemeDtl sa, goods o, gdinput i, vendorh v, store sh Where sh.code = t.storeCode
And sa.storeGid = sh.gid And i.code = t.gdCode and i.gid = o.gid And o.gid = sa.GdGid And v.gid = sa.vdrgid and v.code = t.vendorCode);