select opr.companyname, opr.address, opr.address2, opr.city, opr.state, opr.zipcode, ter.name as territoryName, ter.territoryColor from tbl_opr_clientoperators opr with (nolock) left outer join tbl_ter_territories ter with (nolock) on ter.territoryid = opr.territoryid where opr.ownerid = and opr.fsltablecode = and opr.operatorid = select cdr.cdr_dstname companyname, cdr.cdr_dstaddress1 address, cdr.cdr_dstaddress2 address2, cdr.cdr_dstcity city, cdr.cdr_dststate state, cdr.cdr_dstzip zipcode, ter.name as territoryName, ter.territoryColor from tbl_cdr_distributors cdr with (nolock) left outer join tbl_ter_territories ter with (nolock) on ter.territoryid = cdr.cdr_territoryid where cdr.ownerid = and cdr.fsl_tablecode = and cdr.cdr_recordid =

Start a new call for:

#qryAccount.companyname#
#qryAccount.address#
#qryAccount.city#, #qryAccount.state# #qryAccount.zipcode#

Market: #qryAccount.territoryName#