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
| Erreur SQL !
SELECT pays.pays,indicateur.indicateur,periodicite.periodicite,source.source,description1.description1,description2.description2,DATE_FORMAT(dates,'%m/%d/%Y') ,donnee
FROM donnees,pays,indicateur,source,periodicite,description1,description2
WHERE pays.ID_pays = donnees.ID_pays
AND indicateur.ID_indicateur = donnees.ID_indicateur
AND periodicite.ID_periodicite = donnees.ID_periodicite AND source.ID_source = donnees.ID_source
AND description1.ID_description1 = donnees.ID_description1
AND description2.ID_description2 = donnees.ID_description2
AND `pays` = "Allemagne"
AND `indicateur` = "Croissance du PIB "
AND `periodicite` = "quarter" AND `source` = "source Destatis"
AND `description1` = "variation annuelle en pourcentage" AND dates BETWEEN '2007-01-01'
AND '2020-01-01'
UNION ALL SELECT pays.pays,indicateur.indicateur,periodicite.periodicite,source.source,description1.description1,description2.description2,DATE_FORMAT(dates,'%m/%d/%Y') ,donnee
FROM donnees,pays,indicateur,source,periodicite,description1,description2
WHERE pays.ID_pays = donnees.ID_pays
AND indicateur.ID_indicateur = donnees.ID_indicateur
AND periodicite.ID_periodicite = donnees.ID_periodicite
AND source.ID_source = donnees.ID_source
AND description1.ID_description1 = donnees.ID_description1
AND description2.ID_description2 = donnees.ID_description2
AND `pays` = "Allemagne" AND `indicateur` = "Croissance du PIB " AND `periodicite` = "quarter"
AND `source` = "source Destatis"
AND `description1` = "variation trimestrielle en pourcentage"
AND dates
BETWEEN '2007-01-01'
AND '2020-01-01'
ORDER BY pays, indicateur, periodicite, description1, description2, dates ASC |
Partager