select bro.broker_id, bro.broker_name, mem.fspro_userId as userId, mem.firstName, mem.lastName, mem.title from tblMFRBrokerLink link with (nolock) inner join tblBrokerOffices bo with (nolock) on bo.broker_office_id = link.broker_office_id and bo.broker_id = link.broker_id left outer join tbl_FSPRO_Members mem with (nolock) on mem.primaryOfficeId = bo.broker_office_id inner join tbl_OPR_ClientOperators opr on opr.ownerId = mem.ownerId and opr.fsltablecode = mem.fsl_tablecode and opr.mfr_bsr_id = mem.fspro_userId inner join tblBrokers bro on bro.broker_id = bo.broker_id where link.mfr_id = and opr.fsl_choId = and opr.fsltablecode = 'BRO'