SELECT a.CompensateNo, a.Currency, NVL(a.SumDutyPaid,0) AS AllPay,
NVL(b.SumPay,0) AS RePay, b.ProAccDate
FROM tmp_all a, tmp_reins b
WHERE a.CompensateNo = b.ClaimNo
AND a.Currency = b.Currency
AND ROUND((a.SumDutyPaid * a.CoinsRate/100), 2) <> b.SumPay
ORDER BY b.ProAccDate, a.CompensateNo;
2008年1月7日 17:15