如何获得从联接插入值派生的列？

-2

对于以下示例

CREATE TABLE [dbo].[Customer] (CustomerID int primary key, ShipMethodRef INT)

INSERT INTO  [dbo].[Customer] VALUES (5497, 20);

CREATE TABLE [dbo].ShipMethod(ShipMethodID int PRIMARY KEY, Name varchar(10));

INSERT INTO  [dbo].ShipMethod VALUES (20, 'Fedex'), (21, 'UPS')


UPDATE [dbo].[Customer]  
set ShipMethodRef = CASE WHEN EXISTS (SELECT ShipMethodID from [dbo].[ShipMethod]
                         WHERE [dbo].[ShipMethod].Name = 'UPS') 
                    THEN (SELECT ShipMethodID from [dbo].[ShipMethod] 
                         WHERE [dbo].[ShipMethod].Name = 'UPS')
                    ELSE curTable.ShipMethodRef END
OUTPUT ShipMethod.Name as ShipMethodName
FROM [dbo].[Customer] curTable 
JOIN [dbo].ShipMethod ShipMethod ON curTable.ShipMethodRef = ShipMethod.ShipMethodID
WHERE CustomerID=5497;

该OUTPUT子句返回Fedex-如何更改它以反映客户的运输方式为UPS（因为其运输方式ID现在为21）的插入后状态？