SELECT DISTINCT b.broker_name as brokerName, bo.BROKER_POSTAL_CITY city, bo.broker_postal_state state, bo.broker_postal_zip zip, mbr.fspro_userid, mbr.firstName, mbr.lastName, mbr.salutation, mbr.title, mbr.email, mbr.phone, mbr.phoneext, 'RM''BSR' role FROM tbl_SMA_BrokerOfficeLink bol INNER JOIN tblBrokers b ON b.broker_id = bol.brokerid INNER JOIN tblBrokerOffices bo ON bo.broker_id = bol.brokerid AND bo.broker_office_id = bol.brokerofficeid INNER JOIN tbl_SEC_MemGrpLink sec ON sec.groupid = AND sec.PartnerID = bol.mfr_id AND sec.PartnerTyp = AND sec.BrokerOfficeID = bol.brokerofficeid INNER JOIN tbl_FSPro_Members mbr ON mbr.fspro_userid = sec.fspro_userid WHERE bol.mfr_id = AND bol.territoryId = SELECT DISTINCT b.broker_name as brokerName, bo.BROKER_POSTAL_CITY city, bo.broker_postal_state state, bo.broker_postal_zip zip, mbr.fspro_userid, mbr.firstName, mbr.lastName, mbr.salutation, mbr.title, mbr.email, mbr.phone, mbr.phoneext, 'RM''BSR' role FROM tbl_SMA_BrokerOfficeLink bol INNER JOIN tblBrokers b ON b.broker_id = bol.brokerid INNER JOIN tblBrokerOffices bo ON bo.broker_id = bol.brokerid AND bo.broker_office_id = bol.brokerofficeid INNER JOIN tbl_FSPro_Members mbr ON mbr.fspro_userid = INNER JOIN tbl_SEC_MemGrpLink sec ON sec.groupid = AND sec.PartnerID = bol.mfr_id AND sec.PartnerTyp = AND sec.BrokerOfficeID = bol.brokerofficeid INNER JOIN tbl_FSPro_Members mbr ON mbr.fspro_userid = sec.fspro_userid WHERE bol.mfr_id = AND bol.territoryId = --->