| Sql |
select replace(c.valore_n, '"', '') as ragione_sociale , a.partita_iva, 'P.IVA:'||a.partita_iva as partita_iva_desc, a.valore_n as "totalValueOfProduction", substring(b.valore_n from 2 for 10) AS yearenddate from
(SELECT rowid1, vat_number as partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('totalValueOfProduction')
GROUP BY 1,2,3,4) a
join (SELECT rowid, vat_number as partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('yearEndDate')
GROUP BY 1,2,3,4) b on a.partita_iva=b.partita_iva and a.rowid1=b.rowid
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 group by 1,2,3,4,5
|
