select m.fspro_userId, m.firstName, m.lastName, m.title, m.phone, m.phoneExt, m.email, m.ownerId, m.fsl_tablecode, m.primaryOfficeId, m.officeAddrSame, m.city, m.state from tbl_FSPro_Members m where m.ownerId > 0 and m.fspro_userid = salesPerson.firstName = qmd_memberLookup.firstName; salesPerson.lastName = qmd_memberLookup.lastName; salesPerson.title = qmd_memberLookup.title; salesPerson.email = qmd_memberLookup.email; salesPerson.phone = qmd_memberLookup.phone; salesPerson.phoneExt = qmd_memberLookup.phoneExt; salesPerson.city = qmd_memberLookup.city; salesPerson.state = qmd_memberLookup.state; salesPerson.ownerId = qmd_memberLookup.ownerId; salesPerson.ownerType = qmd_memberLookup.fsl_tablecode; select broker_name from tblBrokers where broker_id = select broker_office_name, broker_city, broker_state, broker_areacode, broker_phone_number from tblBrokerOffices bo where bo.broker_id = and bo.broker_office_id = Evaluate( "caller.#attributes.variable# = salesPerson" );