Re: SELECT IN REPORTS25

Hi

I suppose that's because Reports 2.5 still works with PL/SQL V1 and so doesn't support subquery in from clause

Fred

>Can SomeOne Explain to me why does the Following query works in Sql*plus
>and does not work in
>reports25?
>
>Select Sum(Nvl(Feder,0)) valor_feder From (Select Nvl(Valor_Feder,0)
>Feder
>From rime_pagamento pag, rime_promotor pr
>where pag.cod_projecto = pr.cod_projecto and
>pag.regiao = pr.regiao and
>pag.ano = pr.ano and
>pr.cod_ea = 'BPA' and
>(pag.data_pag <= '98.05.15' and
>(activo = 'S' or activo is null))
>UNION
>Select Nvl(Valor_Feder,0) Feder
>From rime_pagamento pag, rime_promotor pr
>where pag.cod_projecto = pr.cod_projecto and
>pag.regiao = pr.regiao and
>pag.ano = pr.ano and
>pr.cod_ea = 'BTA' and
>(pag.data_pag <= '98.12.31' and
>activo = 'N' ));
>
>Giving me the following error message:
>Error 103
>Encontered the symbol "(" when expecting one of the following:
>< a double-quoted string>
>Fatal syntax error, unable to recover.
Received on Fri May 15 1998 - 13:15:11 CEST