| Sql |
select * from (select replace(c.valore_n, '"','') as ragione_sociale ,'P.IVA:'||c.partita_iva||'' as partita_iva_desc, vv_sup_dip_ateco.ateco_codici as codice_ateco_est,
case when z.zona is null then 'ND'
else
replace(z.zona, '"', '') end as zona,
vv_sup_dip_ateco.descrizione,
vv_sup_dip_ateco.codice_ateco as codice_ateco
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 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 ) rew
group by ragione_sociale, partita_iva_desc, codice_ateco_est, zona, descrizione, codice_ateco
|
