Fórum select dentro de um select em banco firebird #560373
18/08/2016
0
Bom dia , a todos.
Olhei uns exemplos de select dentro de um select estou tentando fazer um aqui e me retorna o seguinte erro:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
count of column list and variable list do not match.
select
ctelin.lincod, ctelin.lindes ,
(select
coalesce(sum(mapqtd),0) as mapqtdtot,
coalesce(sum(maptot+mapvlrdes),0) as mapvlrtot
from
bmbmap
inner join ctepro on ctepro.procod = mappro
where
mapfil = :p_fil and
mapdat between :p_datini and :p_datfim and
prolin = ctelin.lincod and
mapqtd > 0 and mapproest is null),
(Select
mappro, prodes,
coalesce(sum(mapqtd),0) as itemqtd, coalesce(sum(maptot+mapvlrdes),0) as itemtotal,
coalesce(sum(maptot / mapqtd),0) as itemuni
from
bmbmap
inner join ctepro on ctepro.procod = mappro
where
mapfil = :p_fil and
mapdat between :p_datini and :p_datfim and
prolin = ctelin.lincod and
mapqtd > 0 and mapproest is null
group by
mappro, prodes)
from
ctelin
group by
ctelin.lincod, ctelin.lindes
order by
ctelin.lincod
obrigado desde ja pela ajuda.
Olhei uns exemplos de select dentro de um select estou tentando fazer um aqui e me retorna o seguinte erro:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
count of column list and variable list do not match.
select
ctelin.lincod, ctelin.lindes ,
(select
coalesce(sum(mapqtd),0) as mapqtdtot,
coalesce(sum(maptot+mapvlrdes),0) as mapvlrtot
from
bmbmap
inner join ctepro on ctepro.procod = mappro
where
mapfil = :p_fil and
mapdat between :p_datini and :p_datfim and
prolin = ctelin.lincod and
mapqtd > 0 and mapproest is null),
(Select
mappro, prodes,
coalesce(sum(mapqtd),0) as itemqtd, coalesce(sum(maptot+mapvlrdes),0) as itemtotal,
coalesce(sum(maptot / mapqtd),0) as itemuni
from
bmbmap
inner join ctepro on ctepro.procod = mappro
where
mapfil = :p_fil and
mapdat between :p_datini and :p_datfim and
prolin = ctelin.lincod and
mapqtd > 0 and mapproest is null
group by
mappro, prodes)
from
ctelin
group by
ctelin.lincod, ctelin.lindes
order by
ctelin.lincod
obrigado desde ja pela ajuda.
Tiago Schneider
Curtir tópico
+ 0
Responder
Posts
19/08/2016
Jones Granatyr
O SQL interno deve retornar somente um campo. Na suas consultas com SQL dentro do SQL elas estão retornando várias colunas
Responder
Gostei + 0
19/08/2016
Tiago Schneider
Obrigado jones , vou testar
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)