22,209
社区成员
发帖
与我相关
我的任务
分享
[UniCode]
update
ChargeItemAlias
set ChargeItemAlias .Alias=ChargeItem.ItemName
From
ChargeItemAlias inner join ChargeItem on ChargeItemAlias.UniCode=ChargeItem.UniCode
update
ChargeItemAlias
set ChargeItemAlias .Alias=
(SELECT ChargeItem.ItemName FROM ChargeItem WHERE ChargeItemAlias.UniCode=ChargeItem.UniCode)
From ChargeItemAlias