Anilrgowda

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?

------------------

Anilrgowda

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

I think you can not use a table alias with update statement.

------------------