[firebase-br] Dificuldade com union e group by

[Wagner Porto]

Também não.
Ocorre o mesmo erro:

Invalid expression in the select list (not contained in either an 
aggregate function or the GROUP BY clause).

Obrigado.

Gabriel Hilbig escreveu:
> TENTE com DISTINCT
>
>
> select DISTINCT c.codigo, c.desc, sum(i.qtd * i.valor) as "valor"
> from item i
> join cliente c on c.codigo = i.codcli
> union
> select DISTINCT c.codigo, c.desc, sum(s.qtd * s.valor) as "valor"
> from item_servico s
> join cliente c on c.codigo = s.codcli
> union
> select DISTINCT c.codigo, c.desc, sum(e.qtd * e.valor) as "valor"
> from item_escalonamento e
> join cliente c on c.codigo = e.codcli
>
> group by 1,2
>   

-- 
Att.
Wagner Porto