Alias is not allowed in update in SQLSERVER?

Kindly let me know how to update this information..

update ctblworkorder A set (A.strInvoiceLink,A.strInvoiceLink) =
(Select b.ShipOrder,b.ShipVendor from ctblTempWrk001 b
where A.strSerialNumber=b.WOSerial and
A.strReceiveNumber=b.WORecvNo)
Where Exists ( Select 1 from ctblTempWrk001 c
Where A.strSerialNumber=c.WOSerial and
A.strReceiveNumber=c.WORecvNo and
A.strinvoicelink<>c.shiporder )

Can we not update like this in SQL SERVER???

Hi,


Unfortunately SQL Server doesn't support aliases using the standard
ANSI SQL UPDATE syntax. Instead you have to use the FROM clause, which
is a proprietary extension:

UPDATE qi
SET avgcost =
(SELECT avgcost
FROM e_icitems AS ii
WHERE qi.item = ii.item)
FROM quoteitems AS qi;

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

Thanks for your reply. I accept for 1 field update this works. For Multiple fields eg.. I am trying to update File Temp003 from Fields in TEMP001

UPDATE TEMP003 SET (SHIPORDER,SHIPVENDOR) =
(SELECT SHIPORDER,SHIPVENDOR FROM ctblTempWrk001 AS TEMP001
Where TEMP003.WOSERIAL=TEMP001.WOSerial and TEMP003.WORecvNo=TEMP001.WORecvNo )
FROM ctbltempwrk003 AS TEMP003

Incorrect Syntax