select cdr.ownerid, cdr.fsl_tablecode, cdr.cdr_recordid, cdr.cdr_dstname, cdr.cdr_dstcity, cdr.cdr_dststate, cdr.cdr_dstzip, fsl.dstid, fsl.dstname, fsl.dstzip, fsl.dststate, fsl.dstcity from tbl_cdr_distributors cdr inner join tbl_dst_distributors fsl on fsl.dstid = cdr.fsl_dstid order by cdr.fsl_tablecode, cdr.ownerid, cdr.cdr_dstname select cdr.ownerid, cdr.fsl_tablecode, cdr.cdr_recordid, cdr.cdr_dstname, cdr.cdr_dstaddress1, cdr.cdr_dstcity, cdr.cdr_dststate, cdr.cdr_dstzip, fsl.dstid, fsl.dstname, fsl.dstaddr1, fsl.dstzip, fsl.dststate, fsl.dstcity from (select distinct opr.ownerid, opr.fsltablecode, dst.dstid, dst.dstname, dst.dstzip, dst.dststate, dst.dstcity, dst.dstaddr1 from tbl_dst_distributors dst inner join tbl_opr_clientoperators opr on opr.fsl_dstid_1 = dst.dstid left outer join tbl_cdr_distributors cdr on cdr.ownerid = opr.ownerid and cdr.fsl_tablecode = opr.fsltablecode and cdr.fsl_dstid = opr.fsl_dstid_1 where cdr.cdr_recordid is null ) fsl inner join tbl_cdr_distributors cdr on cdr.ownerid = fsl.ownerid and cdr.fsl_tablecode = fsl.fsltablecode and ((fsl.dstzip = cdr.cdr_dstzip and fsl.dstzip <> '') or (fsl.dststate = cdr.cdr_dststate and fsl.dstcity = cdr.cdr_dstcity and fsl.dststate <> '' ) or (fsl.dststate = cdr.cdr_dststate and cdr.cdr_dstcity = '') or (soundex(fsl.dstname) = soundex(cdr.cdr_dstname) and (cdr.cdr_dstzip = '') and cdr.cdr_dststate = '' and cdr.cdr_dstcity = '')) where cdr.fsl_tablecode = 'MFR' and (cdr.fsl_dstid = 0 or cdr.fsl_dstid is null) order by cdr.fsl_tablecode, cdr.ownerid, cdr.cdr_dstname

cdr_dstname	dstname	editDistance
#distributorMatches.fsl_tablecode#-#distributorMatches.ownerId#
#dstname# #dstcity# #dststate# #dstzip#	#cdr_dstname# #cdr_dstcity# #cdr_dststate# #cdr_dstzip#	#editDistance#

Matched #matchCount# of #candidateCount#