Ta na mão a solução.
SELECT
cli.nome,
cli.idcli,
dep.dependente,
pla.valor,
pla.plano,
par.parentesco
FROM (SELECT c.idcli,
c.nome,
count(*) as qtde_dependente
FROM clifor c
INNER JOIN dependentes d ON d.idcli = c.idcli
GROUP BY c.idcli,
c.nome) AS cli
INNER JOIN dependentes dep ON dep.idcli = cli.idcli
INNER JOIN plano pla ON pla.idplano = cli.qtde_dependente
INNER JOIN parentes par ON par.idparente = dep.parentesco
ORDER BY cli.nome;
Att,
Paulo.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
