我正在尝试执行以下更新语句:
Update belege2
Set Preis_Einh = x.Preis, Aktion=x.Aktion, PreisHerk = x.PreisHerk
FROM dbo.GetPreis(belege2.prodkey, belege2.Anzahl) x
where belege2.Beleg_Nr = 13599
SQL Server 显示以下错误:
Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "belege2.prodkey" could not be bound.
Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "belege2.Anzahl" could not be bound.
这不被支持吗?有解决方法吗?