Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select v.codigo, COALESCE(pf.nome,pj.razaosocial) as titular, COALESCE(COALESCE(pfcc.nome,pjcc.razaosocial), '') as conjuge, COALESCE(COALESCE(pfcc.cpf), '') as conjugeCPF,pfcc.rg as "RG do Conjugue", string_agg(COALESCE(pfcs.nome,pjcs.razaosocial), ', ') as socios, pfcs.rg as "RG do Sócio", COALESCE(COALESCE(pfcs.cpf), '') as "CPF do Sócio"
- from venda v
- inner join comprador c on (c.fkvenda = v.pkvenda and c.fkconjuge is null and c.titular is true)
- left outer join cliente cl on (cl.pkcliente = c.fkcliente)
- left outer join pessoa p on (p.pkpessoa = cl.fkpessoa)
- left outer join pessoafisica pf on (pf.pkpessoafisica = p.fkpessoafisica)
- left outer join pessoajuridica pj on (pj.pkpessoajuridica = p.fkpessoajuridica)
- left outer join comprador cc on (cc.fkvenda = v.pkvenda and cc.fkconjuge is not null)
- left outer join cliente clcc on (clcc.pkcliente = cc.fkcliente)
- left outer join pessoa pcc on (pcc.pkpessoa = clcc.fkpessoa)
- left outer join pessoafisica pfcc on (pfcc.pkpessoafisica = pcc.fkpessoafisica)
- left outer join pessoajuridica pjcc on (pjcc.pkpessoajuridica = pcc.fkpessoajuridica)
- left outer join comprador cs on (cs.fkvenda = v.pkvenda and cs.fkconjuge is null and cs.titular is false)
- left outer join cliente clcs on (clcs.pkcliente = cs.fkcliente)
- left outer join pessoa pcs on (pcs.pkpessoa = clcs.fkpessoa)
- left outer join pessoafisica pfcs on (pfcs.pkpessoafisica = pcs.fkpessoafisica)
- left outer join pessoajuridica pjcs on (pjcs.pkpessoajuridica = pcs.fkpessoajuridica)
- where v.codigo ilike '017 %'
- and v.status = 0
- GROUP BY v.codigo, COALESCE(pf.nome,pj.razaosocial), COALESCE(pfcc.nome,pjcc.razaosocial), COALESCE(pfcc.cpf),pfcc.rg,pfcs.rg,COALESCE(pfcs.cpf)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement