Posts by Carlos • 31 points
2 posts
-
1
votes1
answer23
viewsA: I want to group database data (Firebird) to send emails
I got the desired result using: select CODIGO, LIST(DESCRICAO,',') as DESCRICRAO, LIST(distinct(NOME)) as Nome, LIST(distinct(EMAIL)) as Email, List(distinct(Tot)) as Total FROM(SELECT…
-
2
votes1
answer23
viewsQ: I want to group database data (Firebird) to send emails
Good, I am selecting the data for sending the email in this SELECT: SELECT V.id_venda_cab, V.id_cliente, V.Total, C.nome, i.id_produto, p.descricao, C.email FROM VENDA_CAB V INNER JOIN CLIENTE C ON…