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 where BROKER_OFFICE_ID = select broker_name from tblbrokers where broker_id = and 'bro' = SELECT b.GroupName FROM tbl_SEC_MemGrpLink a, tbl_SEC_Groups b WHERE FSPro_UserID = AND a.GroupID = b.GroupID AND GroupTypeCD = 'SME' ORDER BY GroupName select distinct territoryid, territoryName from qmd_territoryTeam order by territoryname

#encodeForHTML(qryContact.firstname)# #encodeForHTML(qryContact.lastname)#
#encodeForHTML(qryContact.title)#
#encodeForHTML(qryBroInfo.broker_name)#

#qryPrimaryOffice.BROKER_STREET_ADDRESS#
#qryPrimaryOffice.BROKER_STREET_ADDRESS2#
#qryPrimaryOffice.BROKER_CITY#, #qryPrimaryOffice.BROKER_STATE# #qryPrimaryOffice.BROKER_ZIP#

#encodeForHTML(qryContact.email)#

LinkedIn Profile