select broker_Id, broker_Name, oneFSschoolsPartner from tblBrokers with (nolock) where broker_Id in ( select ownerId from tbl_OPR_clientOperators with (nolock) where FSL_choId = and FSLTableCode = 'BRO' ) order by broker_Name