hello
I have a small question regarding sql in oracle.
I have a question about Upadting with inner join in sql.
UPDATE MOJOJO
SET MOJOJO.CarMaker = mstMakerModel.Maker
FROM tblCarAuctionList AS MOJOJO INNER JOIN
mstMakerModel ON MOJOJO.CarName = mstMakerModel.Model
It prompts that "CarMaker is not updatable".
Can somebody give me the proper syntax?
Please help me regarding this problem
Bookmarks