SELECT * from tbl_CDR_Distributors d INNER JOIN ( select OwnerID, FSL_TableCode, cdr_dstName, fsl_dstid, COUNT(fsl_dstid) as count from tbl_CDR_Distributors WHERE OwnerID > 0 AND FSL_dstid <> 0 Group by OwnerID, FSL_TableCode, fsl_dstid, cdr_dstName HAVING COUNT(fsl_dstid) > 1) x ON d.OwnerID = x.OwnerID AND d.cdr_dstname = x.cdr_dstname AND d.fsl_dstid = x.fsl_dstid ORDER BY d.OwnerID, d.cdr_dstname, d.fsl_dstid, cdr_recordid asc Update tbl_CDR_Distributors SET FSL_mapPriority = #y_norder#, FSL_masterlinkYN = '#y_n#' WHERe cdr_recordid = #qry_getData.cdr_recordid#
#y_n# - #y_norder# | #qry_getData.OwnerID#, #qry_getData.FSL_TableCode#, #qry_getData.cdr_dstname#, #qry_getData.FSL_dstid#, #qry_getData.FSL_mapPriority#, #qry_getData.FSL_masterlinkYN#