[pgbr-geral] Fw: REF. MONTAR SELECT.

Fri, 29 Oct 2010 17:55:49 -0700 

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
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a