[firebase-br] Ajuda em Select

[Edy GB]

Ok.... porque esse instrução não funciona e......

SELECT EXTRACT(MONTH FROM V.ENTRADA) AS MES, P.PRODUTO, SUM(V.TOTAL) ,
(SELECT SUM(V1.TOTAL) FROM GRITE01 V1 WHERE V1.ENTRADA BETWEEN '01.08.2005' 
AND '30.08.2005'
AND V1.CPRO = P.CODIGO)TOTPRO
FROM GRITE01 V, GRPRO P WHERE
V.ENTRADA BETWEEN '01.05.2005' AND '30.08.2005'
AND V.CPRO = P.CODIGO
Group By 2,1


Depois que tiro o SubSelect Funciona

SELECT EXTRACT(MONTH FROM V.ENTRADA) AS MES, P.PRODUTO, SUM(V.TOTAL)
FROM GRITE01 V, GRPRO P WHERE
V.ENTRADA BETWEEN '01.05.2005' AND '30.08.2005'
AND V.CPRO = P.CODIGO
Group By 2,1

_________________________________________________________________
MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com