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)