1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SELECT
req.c_rmpm_code,
req.c_rating_agency_sp,
req.c_rating_agency_mo,
req.c_rating_agency_fi,
max(req.date_autre_agence),
req.note_autre_agence,
req.code_autre_agence
FROM
(SELECT *
FROM rdt_fs_histo_mca a
LEFT JOIN (SELECT mc.d_rating_date as date_autre_agence,
mc.c_current_rating as note_autre_agence,
mc.c_current_agency as code_autre_agence
FROM rdt_fs_histo_mca mc
WHERE mc.c_current_agency='MO') b
ON a.d_rating_date >= nvl(b.date_autre_agence, '01/01/0001')
AND a.c_current_agency='SP'
WHERE a.c_current_agency='SP') req
GROUP BY
req.c_rmpm_code,
req.c_rating_agency_sp,
req.c_rating_agency_mo,
req.c_rating_agency_fi,
req.note_autre_agence,
req.code_autre_agence |
Partager