select BROKER_STREET_ADDRESS, BROKER_STREET_ADDRESS2, BROKER_CITY, BROKER_STATE, BROKER_ZIP, BROKER_AREACODE, BROKER_PHONE_NUMBER,
BROKER_FAX_AREACODE, BROKER_FAX_NUMBER
from tblBrokerOffices with (nolock)
where BROKER_OFFICE_ID =
select broker_name
from tblbrokers with (nolock)
where broker_id =
and 'bro' =
select g.groupName
from tbl_SEC_MemGrpLink mgl with (nolock)
inner join tbl_sec_groups g with (nolock)
on g.groupid = mgl.groupid
and g.groupTypeCd = 'SME'
where mgl.fspro_userid =
select distinct territoryid, territoryName
from qmd_territoryTeam
order by territoryname