Bonjour,

Je suis débutant sous FB et j'arrive pas à faire la requête suivante

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
 
SELECT REFDATE, sum(msg_recu) as recu, sum(msg_Traite) as Traite from (
SELECT EXTRACT(MONTH FROM ME_DATE) as REFDATE, Count(ME_DATE) AS msg_recu,CAST('0',INTEGER) AS msg_Traite FROM MESSAGES WHERE ME_DATE Between '2007/01/01' And '2007/12/31' GROUP BY EXTRACT(MONTH FROM ME_DATE) 
union
SELECT EXTRACT(MONTH FROM ME_DATETRAITEMENT) as REFDATE, CAST('0',INTEGER) AS msg_recu, Sum(ME_TRAITE) AS msg_Traite FROM MESSAGES WHERE ME_DATETRAITEMENT Between '2007/01/01' And '2007/12/31' GROUP BY EXTRACT(MONTH FROM ME_DATETRAITEMENT)
)
GROUP BY Mois;

Le message d'erreur me dit : "Token unknow -line 2, char 1 SELECT"


Merci de votre aide