Recherche:

Apparemment dans MySQL les requête imbriquées doivent avoir un alias


SELECT resultat.col1, resultat.col2 FROM (
(SELECT nom AS col1, département AS col2, cote AS col3 FROM TABLE A)
union...

Normalement un truc de ce genre doit marcher


select col1, col2 from (
(select nom as col1, département as col2, cote as col3 from Table A)
union
(select nom as col1, ville as col2, cote as...