| Sql |
select replace(c.valore_n, '"', '') as ragione_sociale , replace(d.valore_n, '"', '') as codice_ateco , c.partita_iva, 'P.IVA:'||c.partita_iva as partita_iva_desc, replace(a.valore_n, '"', '') as numero_dipendenti, replace(z.zona, '"', '') as zona from
(SELECT rowid1, vat_number as partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('numberOfEmployees'))a
right join
(select id, valore_n, campo, partita_iva from public.v_company_deaggr where campo='name' group by 1,2,3,4)c on c.partita_iva=a.partita_iva
left join
(select id,valore_n, campo, partita_iva from public.v_company_deaggr where campo='activityCode' group by 1,2,3,4)d on c.id=d.id
left join
(select valore_n as zona, vat_number as partita_iva from public.v_settlement_deaggr where campo='zona' group by 1,2) z on c.partita_iva=z.partita_iva
|
