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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| SELECT * from (
SELECT
scot.libelle_scot as libelle,
sum(epls.logtot2010)"log_tot_10",
sum(epls.logtot2009)"log_tot_09",
sum(epls.logtot2008)"log_tot_08",
sum(epls.logtot2007)"log_tot_07",
sum(epls.logtot2006)"log_tot_06",
sum(epls.logtot2005)"log_tot_05",
sum(epls.logtot2004)"log_tot_04",
sum(epls.logtot2003)"log_tot_03",
sum(epls.logtot2002)"log_tot_02",
sum(epls.logtot2001)"log_tot_01",
sum(epls.logtot2000)"log_tot_00",1 as selection
FROM
tables_de_references.commune,
meddtl.epls,
tables_de_references.scot
WHERE
commune.codgeo = epls.codgeo AND
scot.code_scot = commune.scot
GROUP BY
scot.code_scot
UNION
SELECT
commune.libelle_commune as libelle,
sum(epls.logtot2010)"log_tot_10",
sum(epls.logtot2009)"log_tot_09",
sum(epls.logtot2008)"log_tot_08",
sum(epls.logtot2007)"log_tot_07",
sum(epls.logtot2006)"log_tot_06",
sum(epls.logtot2005)"log_tot_05",
sum(epls.logtot2004)"log_tot_04",
sum(epls.logtot2003)"log_tot_03",
sum(epls.logtot2002)"log_tot_02",
sum(epls.logtot2001)"log_tot_01",
sum(epls.logtot2000)"log_tot_00",2 as selection
FROM
tables_de_references.commune,
meddtl.epls,
tables_de_references.scot
WHERE
commune.codgeo = epls.codgeo AND
scot.code_scot = commune.scot
GROUP BY
commune.libelle_commune;) as Complet
GROUP BY libelle,selection |
Partager