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
|
SELECT
CASE WHEN Clients.C_PaysRes = '250' AND Clients.C_RaisonSoc IS NULL
THEN SUM(Pi_Montant)
END AS MntParRes,
CASE WHEN Clients.C_PaysRes = '250' AND Clients.C_RaisonSoc IS NOT NULL
THEN SUM(Pi_Montant)
END AS MntSocRes,
CASE WHEN Clients.C_PaysRes <> '250' AND Clients.C_RaisonSoc IS NULL
THEN SUM(Pi_Montant)
END AS MntParNonRes,
CASE WHEN Clients.C_PaysRes <> '250' AND Clients.C_RaisonSoc IS NOT NULL
THEN SUM(Pi_Montant)
END AS MntSocNonRes
FROM Pat_Interet, Pat_Credit, Pat_Emprunt, Clients
WHERE Pi_Date_Envoi BETWEEN '2009/06/01' AND '2009/06/30'
AND Pat_Interet.PI_Credit = Pat_Credit.Id_credit
AND Pat_Emprunt.Id_credit = Pat_Credit.Id_credit
AND Pat_Emprunt.Ref_client = Clients.C_RefCliLie
AND Pat_Interet.PI_Statut = 1
AND Pat_Credit.Duree between 12 and 60 -- > 5 ans
GROUP BY Clients.C_RaisonSoc, C_PaysRes |
Partager