| Sql |
select fir.rowid, fir.partita_iva, fir.numerodip, fir.ateco_codici, x.descrizione_ateco from
(select a.rowid, a.partita_iva , a.valore_n as numerodip, unnest(string_to_array(replace(replace(replace(replace(replace(replace(replace(b.valore_n, 'S', ''), 'D', ''), 'I', ''), 'P', ''), 'A', ''), '"', ''), '\r\n', ''), '/')) as ateco_codici from
(SELECT rowid, vat_number as partita_iva ,campo, valore_n
FROM v_settlement_deaggr where campo in ('numerodip') )a
left join
(SELECT rowid, vat_number as partita_iva ,campo, valore_n
FROM v_settlement_deaggr where campo in ('ateco_codici')) b on a.partita_iva=b.partita_iva and a.rowid=b.rowid )fir
left join
(select * from x_codici_ateco) x on x.codice_ateco_est=trim(fir.ateco_codici) or x.codice_ateco=trim(fir.ateco_codici)
|
