010

case when campo15>campo11 then 1 else case when campo12 in ('ST_495','ST_612','ST_642','ST_500') then 1 else 0 end end

case when campo14='1' then campo4::numeric(27,12) else 0 end

case when campo14='1' and campo12 not in ('ST_495','ST_612','ST_642','ST_500') then 0 else campo4::numeric(27,12) end

select campo17 from {TABLE} a 
where
a.campo1={TABLE}.campo1 AND
a.campo2={TABLE}.campo2 AND
a.campo3={TABLE}.campo3 AND
a.campo9={TABLE}.campo9 AND
a.campo10={TABLE}.campo10 AND
a.campo11::int = {TABLE}.campo15::int-1
AND a.campo12={TABLE}.campo12 
AND a.cod_import='010' 
AND a.cod_mappatura='30'

select {TABLE}.campo17::numeric-a.campo17::numeric from {TABLE} a 
where
a.campo1={TABLE}.campo1 AND
a.campo2={TABLE}.campo2 AND
a.campo3={TABLE}.campo3 AND
a.campo9={TABLE}.campo9 AND
a.campo10={TABLE}.campo10 AND
a.campo11::int+2= {TABLE}.campo15::int AND
a.campo12={TABLE}.campo12 AND
a.cod_import='010'  AND
a.cod_mappatura='30'

campo18 order by campo11

case when campo12 in('ST_495','ST_612','ST_642','ST_500') then campo18::numeric(27,13) else campo13::numeric(27,13)*campo18::numeric(27,13) end

SELECT COD_VALUTA FROM AZIENDA where COD_AZIENDA=campo1

SELECT COD_VALUTA FROM AZIENDA where COD_AZIENDA=campo22

case when campo11=campo15 then  '1' else '0' end

case when campo11>campo15 then '1' else '0' end