删除重复记录

 

DELETE TMP_ConvTran    WHERE TMP_ConvTran.TransactionNo IN ( SELECT C.TransactionNo     FROM TMP_ConvRetail C      INNER JOIN TMP_ConvTran P     ON C.TransactionNo = P.TransactionNo    AND C.CustomerCode = P.CustomerCode)    AND  TMP_ConvTran.CustomerCode    IN (       SELECT C.CustomerCode    FROM TMP_ConvRetail C    INNER JOIN TMP_ConvTran P    ON C.TransactionNo = P.TransactionNo     AND C.CustomerCode = P.CustomerCode)  DELETE FROM TMP_ConvRate    WHERE NOT EXISTS (SELECT *    FROM TMP_ConvTran    WHERE TMP_ConvRate.TransactionNo = TMP_ConvTran.TransactionNo)