查询同一单位最高货主级别的信息

select a.CompanyId,a.CompanyFatherID from wms_clientcompany a  where not  exists(select * from wms_clientcompany  where state=0 and zjsid=1 and CompanyID=a.CompanyFatherID) and a.state=0 and a.zjsid=1  ;