用友U8.72 SQL查询供应商名称

select cVenName 供应商名称,cVenCode  供应商编码,cVenAbbName 供应商简称,convert(varchar(10),dVenDevDate,120) 发展日期,cVenPhone 电话,
 cVenPerson 联系人,(Person.cPersonName) 专营业务员,(Department.cDepName) 分管部门,convert(varchar(10),(Vendor.dEndDate),120) 停用日期
from  Vendor  
 Left Join DistrictClass on Vendor.cDCCode=DistrictClass.cDCCode  
 Left Join  Person on Vendor.CVenPPerson=Person.cPersonCode  
 Left Join  Department on Vendor.cVenDepart=Department.cDepCode  
where  (1=1) 
 and cVenCode not in (select top 0 cVenCode from Vendor where (1=1)  Order by cVenCode ASC)
--   and cvenabbname like '%供应商名称%'   --简称

 Order by cVenCode ASC