select b.broker_id as pkId, b.broker_name as name from tblBrokers b where exists ( select * from tbl_LIB_Companies where companyPKeyId = b.broker_id and companyPType = 'BRO' ) and exists ( select * from tbl_OPR_ClientSegments where ownerId = b.broker_id and fsl_tablecode = 'BRO' ) order by b.broker_name select m.mfr_id as pkId, m.mfr_name as name from tblManufacturers m where exists ( select * from tbl_LIB_Companies where companyPKeyId = m.mfr_id and companyPType = 'MFR' ) and exists ( select * from tbl_OPR_ClientSegments where ownerId = m.mfr_id and fsl_tablecode = 'MFR' ) order by m.mfr_name select c.cho_id as pkid, c.cho_name as name from tbl_CHO_Operators c where exists ( select * from tbl_LIB_Companies where companyPKeyId = c.cho_id and companyPType = 'CHO' ) order by c.cho_name

Geo Dupes
-- Select OwnerType -- Broker Manufacturer
-- Select Broker Manufacturer Chain Operator Library Account -- #htmleditformat( name )#