Error - View Single Post

**Anilrgowda** · 22-Oct-2007, 12:43 AM

Question: Hello. I have a question about UPDATE with INNER JOIN.

UPDATE AliasA
SET AliasA.CarMaker = mstMakerModel.Maker
FROM tblCarAuctionList AS AliasA INNER JOIN
mstMakerModel ON AliasA.CarName = mstMakerModel.Model

It says that "CarMaker is not updateable". Can somebody give me the proper syntax?

22-Oct-2007, 12:43 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	UPDATE with INNER JOIN SQL Server Question: Hello. I have a question about UPDATE with INNER JOIN. UPDATE AliasA SET AliasA.CarMaker = mstMakerModel.Maker FROM tblCarAuctionList AS AliasA INNER JOIN mstMakerModel ON AliasA.CarName = mstMakerModel.Model It says that "CarMaker is not updateable". Can somebody give me the proper syntax? ------------------