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
Partager