40

Select *From (SELECT 	a.cod_scenario AS Scenario,	a.cod_azienda AS Entity,	a.cod_conto AS Account,	a.cod_dest1 AS CostCenter,	a.cod_dest4 AS Employee,	a.note AS EmployeeInfo,	concat(date_part('Year', to_timestamp(((b.note::int - 25569) * 86400))),'FCT') AS FCST_YR,	c.desc_dest40 AS EmployeeDesc,'Filled' as flag           FROM(SELECT cod_scenario,cod_azienda,cod_conto,cod_dest1,cod_dest4,note FROM dati_note UNIONSELECT cod_scenario,cod_azienda,cod_conto,cod_dest1,cod_dest4,Importo::varchar(100) FROM dati_saldi_lordi WHERE cod_conto in ('ST_612','ST_500'))aINNER JOIN dati_note bON 	(	a.cod_scenario=b.cod_scenario AND	a.cod_azienda=b.cod_azienda AND	a.cod_dest1=b.cod_dest1 AND	a.cod_dest4=b.cod_dest4 AND	b.cod_conto='ST_410'	)INNER JOIN dest4 con a.cod_dest4=c.cod_dest4WHERE 	a.cod_dest4 like 'TBH_%'	 and a.cod_conto in ('ST_400','ST_410','ST_420','ST_430','ST_450','ST_510','ST_520','ST_530','ST_612','ST_500','ST_680','ST_685','ST_675')     and a.cod_scenario={3}     and a.cod_azienda={1}     and a.cod_dest1={2}	 )X	Where not exists	(Select *	From	(Select *	From dati_note	Where cod_conto='ST_451'			and note='Filled') y	where 	x.Scenario=y.cod_scenario AND	x.Entity=y.cod_azienda AND	x.CostCenter=y.cod_dest1 AND	x.Employee=y.cod_dest4 	)

SELECT  Campo1 as Scenario,campo2 as Entity,campo3 as Account,Campo4 as CostCenter,'ST_530' as CodConto,campo5 as oldEmpID,campo11 as EmpID,campo16 as EmpDesc,campo17 as flagFROM MAP_DATI_TRASFORMATI where cod_mappatura='40' and cod_import='010' and campo13='1' and campo1={3} and campo2={1} and campo4={2}