select #qmd_matchingOperators.columnList# from qmd_matchingOperators union select #qmd_matchingOperators.columnList# from qmd_matches order by companyNameEditDistance, addressEditDistance select #qmd_matchingOperators.columnList# from qmd_matchingOperators union select #qmd_matchingOperators.columnList# from qmd_matches select * from qmd_matches order by companyNameEditDistance, addressEditDistance select opr.companyName, opr.operatorId, opr.dbaName, opr.address, opr.address2, opr.city, opr.state, opr.zipCode, ter.name territoryName, ter.territoryId, opr.mfr_bsr_id from tbl_OPR_ClientOperators opr inner join tbl_TER_Territories ter on ter.territoryId = opr.territoryId and ter.ownerId = opr.ownerId and ter.fsl_tablecode = opr.fsltablecode where opr.crmActive = 'Y' and opr.ownerId = and opr.fsltablecode = and ( 1 = 2 or opr.companyName like or opr.dbaName like or opr.zipcode like or opr.state = ) and ter.territoryId in ( ) order by companyName select firstName, lastName from tbl_FSPro_members where fspro_userId = and staffMember = 1 and ownerId = and fsl_tablecode =

Local Market	Operator Company	Address
#htmleditformat( territoryName )#	#htmleditformat( companyName )# Sales Rep: #htmleditformat( salesRepName )#UNASSIGNED	#htmleditformat( address )# #htmleditformat( city )# #htmleditformat( state )# #htmleditformat( zipCode )#
No matches. Use the keyword search below.
Add a new Operator Company