select broker_office_name from tblBrokerOffices with (nolock) where broker_office_id = select broker_name from tblbrokers with (nolock) where broker_id =
Office: #qryBrokerOffice.broker_office_name#