| Sql |
select c.valore_n as ragione_sociale , a.user_id , a.partita_iva, 'P.IVA:'||a.partita_iva||'' as partita_iva_desc, a.valore_n as "shareCapital", substring(b.valore_n from 2 for 10) AS yearenddate, substring(b.valore_n from 2 for 10)::TIMESTAMP AS datetime from
(SELECT user_id , partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('shareCapital')
GROUP BY 1,2,3,4) a
left join (SELECT user_id , partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('yearEndDate')
GROUP BY 1,2,3,4) b on a.user_id= b.user_id and a.partita_iva=b.partita_iva
left join (select valore_n, campo, partita_iva from public.v_company_deaggr where campo='name' group by 1,2,3) c on a.partita_iva=c.partita_iva;
|
