select cdr.cdr_recordid, cdr.cdr_dstname, cdr.cdr_dstcity, cdr.cdr_dststate from tbl_opr_clientoperators opr inner join tbl_cdr_distributors cdr on cdr.cdr_recordid = opr.Distrib1 where opr.ownerid = and opr.fsltablecode = and opr.operatorid = select cdr.cdr_recordid, cdr.cdr_dstname, cdr.cdr_dstcity, cdr.cdr_dststate from tbl_opr_clientoperators opr inner join tbl_cdr_distributors cdr on cdr.cdr_recordid = opr.Distrib2 where opr.ownerid = and opr.fsltablecode = and opr.operatorid =

Primary/Secondary Distributor checked /> #qryPrimaryDist.cdr_dstname#, #qryPrimaryDist.cdr_dstcity# #qryPrimaryDist.cdr_dststate# checked /> #qrySecondaryDist.cdr_dstname#, #qrySecondaryDist.cdr_dstcity# #qrySecondaryDist.cdr_dststate#

Search Results

no distributors found

no distributors found with keyword#iif(listlen(url.keyword," ") gt 1,de("s"),de(""))# "#url.keyword#"

#companyname#
#city# #state#
#accountCode#

find distributors by keyword above

#_lowerPagerDisplay#