1 2 3 4 5 6 7
| SELECT champ01,champ02,champ03,champ04,champ05 FROM
{
SELECT champ01,champ02,champ03,SUM(champ04) AS champ04,SUM(champ05) AS champ05 FROM MABASE WHERE champ01 CONCAT champ02 CONCAT champ03 BETWEEN 'xxxxxxxx' AND 'xxxxxxxx' AND champ04=xxxxxx AND champ05='xx' GROUP BY champ01,champ02,champ03,champ04,champ05
UNION ALL
SELECT champ01,champ02,champ03,SUM(champ04) AS champ04,SUM(champ05) AS champ05 FROM MABASE2 WHERE champ01 CONCAT champ02 CONCAT champ03 BETWEEN 'xxxxxxxx' AND 'xxxxxxxx' AND champ04=xxxxxx AND champ05='xx' GROUP BY champ01,champ02,champ03,champ04,champ05
} AS TEMP
GROUP BY champ01,champ02,champ03,champ04,champ05 |
Partager