| Sql |
select replace(c.valore_n, '"','') as ragione_sociale ,'P.IVA:'||c.partita_iva||'' as partita_iva_desc, replace(a.valore_n, '"', '') as codice_ateco,
case when z.zona is null then 'ND'
else
replace(z.zona, '"', '') end as zona,
vv_sup_dip_ateco.descrizione
from
(select id, valore_n, campo, partita_iva from public.v_company_deaggr where campo='name' group by 1,2,3,4)c
left join
(select id,valore_n, campo, partita_iva from public.v_company_deaggr where campo='activityCode' group by 1,2,3,4)a on a.id=c.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
left join
vv_sup_dip_ateco on c.partita_iva = vv_sup_dip_ateco.partita_iva
|
