quote:

---

Originally posted by tariq2

Hi,
in the following I am trying to update
the AOT value in cte1 with the faotaot value in cte2.
Unfortunately I receive ' The multi-part identifier cte1.faotaot could not be bound'
Many thanks in advance

with cte1 as
(
select JobKey,SUM(aot) as faotaot from F_AOT where PeriodKey <=96
AND PeriodKey >=85 AND BUKey in
(select bukey from d_businessunits where TerritoryName = 'France' AND YEAR = '2010')
AND LedgerKey = 20
group by jobkey

)
,cte2 as
(
select * from F_AOGM where PeriodKey = 96 AND JobKey IN
(select JobKey from D_JobAttributes where BUKey in
(select bukey from d_businessunits where TerritoryName = 'France'))
)
update b
set AOT = a.faotaot
from cte1 a inner join cte2 b
on a.JobKey = b.JobKey

---