1 2 3 4 5 6 7 8 9 10
|
SELECT dbo.rubrique_budgetaire.code_rubrique, dbo.rubrique_budgetaire.rubrique, SUM(dbo.etat_engagement.montant_engager) AS total_engager,
(SELECT SUM(ISNULL(montant, 0)) AS total_modifier
FROM dbo.modification_engager
WHERE (dbo.etat_engagement.id2 = id2)
GROUP BY id2) AS total_modifier,
FROM dbo.etat_engagement LEFT OUTER JOIN
dbo.rubrique_budgetaire ON dbo.etat_engagement.id1 = dbo.rubrique_budgetaire.id1 LEFT OUTER JOIN
dbo.etat_mandatement ON dbo.etat_engagement.id2 = dbo.etat_mandatement.id2
GROUP BY dbo.rubrique_budgetaire.code_rubrique, dbo.rubrique_budgetaire.rubrique, dbo.etat_engagement.id2 |
Partager