[firebase-br] sql com union all

[Augusto]

tente botar

EXTRACT(MONTH FROM CABEC.DEN_LEC)

no order by no lugar do MES

Augusto


----- Original Message ----- 
From: "Henery Linck Rosenhaim" <henery em multi-informatica.com.br>
To: "FireBase" <lista em firebase.com.br>
Sent: Thursday, August 25, 2005 2:42 PM
Subject: [firebase-br] sql com union all


> Eu preciso fazer essa consulta funcionar... o banco é firebird 1.5.2
> o erro que me apresenta é esse... já tentei de tudo, .. mas nada 
> funciona... por favor, se alguem puder ajudar.. é urgente....
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Invalid command.
> invalid ORDER BY clause.
>
>
> SELECT EXTRACT(MONTH FROM CABEC.DEN_LEC) AS MES,
>       CAST('ENTRADA' AS CHAR(7)) AS MOVIMENTO,
>       CABEC.VAL_LEC   AS VALCONT,
>       CONFNAT.DCA_CNL AS DESPRESAR,
>       CAST('P' AS CHAR(1)) AS TIPO,
>       (REF_LEC) AS LANC
> FROM TBLEC CABEC LEFT JOIN
>     TBCNL CONFNAT ON (CABEC.NAT_LEC = CONFNAT.NAT_CNL)
> WHERE ( EXTRACT(YEAR FROM CABEC.DEN_LEC) = 2005 )
> UNION ALL
> SELECT EXTRACT(MONTH FROM CABEC.DEM_LSC) AS MES,
>       CAST('SAIDA' AS CHAR(7)) AS MOVIMENTO,
>       CABEC.VAL_LSC   AS VALCONT,
>       CONFNAT.DCA_CNL AS DESPRESAR,
>       CAST('P' AS CHAR(1)) AS TIPO,
>       (REF_LSC) AS LANC
> FROM TBLSC CABEC LEFT JOIN
>     TBCNL CONFNAT ON (CABEC.NAT_LSC = CONFNAT.NAT_CNL)
> WHERE ( CAN_LSC <> 'S' ) and
>      ( EXTRACT(YEAR FROM CABEC.DEM_LSC) = 2005 )
> ORDER BY MES
>
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado em www.bavs.com.br
> Para editar sua configuração na lista, use o endereço 
> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
> Para consultar mensagens antigas: http://firebase.com.br/pesquisa
>