1 2 3 4 5 6 7 8 9
| SELECT agence.idregion, agence.idagence, temps.Annee, temps.Semestre, temps.Trimestre, temps.Mois, prevision.caprev, SUM( ventepmu.carealise ) AS SommeDecarealise
FROM agence, ventepmu, prevision, temps
WHERE (agence.idagence = ventepmu.idagence)
AND (ventepmu.idtemps = temps.idtemps)
AND (prevision.mois = temps.Mois)
AND (prevision.annee = temps.Annee)
AND (prevision.idagence = agence.idagence)
AND (prevision.idfamille = 'PMU')
GROUP BY agence.idregion, agence.idagence, temps.Annee, temps.Semestre, temps.Trimestre, temps.Mois, prevision.caprev |
Partager