Как использовать функцию агрегации в UPDATE?

Question

[cicatrix]

with [dct] as 
(
	select [boxid], [operator], [palletid], count([newstamp]) [stampscount]
	from [ViewDCTData]
	group by [boxid], [operator], [palletid]
)
update [b]
set 
	[b].[packdate] = getdate(),
	[b].[operator] = [dct].[operator],
	[b].[palletid] = [dct].[palletid],
	[b].[stamps] = [dst].[stampscount]
from [boxes] [b]
inner join [dct] on [dct].[boxid] = [b].[id]

Ошибка:

Msg 4104, Level 16, State 1, Line 12
The multi-part identifier "dst.stampscount" could not be bound.

Почему нельзя использовать функцию агрегации в таком запросе?

Answer 1

[Константин Цветков]

[dst] != [dct]

Comments

[cicatrix]

Спасибо! Всё оказалось очень просто :)