Update Query

[Edgar Thoemmes]

I am trying to updates some costs in my database. I have the following
tables:

tblCopies(CopyId, BookID[fk to tblbookdetails], Condition,Price)
tblBookDetail(BoodId, ISBN, Author)
tblBook/AuthortblPrices(ISBN, Quantity, UnitPrice)
tblPrices(ISBN, Quantity, UnitPrice)

I am trying to update the price in tblcopies with the price in tblPrices.
The query must edit the same number of records in tblCopies as is in the
quantity field in tblPrices. For example I may have 100 copies of BookID 152
but I only want to update 5 of them which is in the Quantity field in
tblprices

My SQL so far:

UPDATE Table1 INNER JOIN (tblBookDetails INNER JOIN tblCopies ON
tblBookDetails.BookID = tblCopies.BookID) ON Table1.ISBN =
tblBookDetails.ISBN SET tblCopies.TotalCost = [Table1]![UnitPrice];

 

[Edgar Thoemmes]

Sorry SQL should read:

UPDATE Table1 INNER JOIN (tblBookDetails INNER JOIN tblCopies ON
tblBookDetails.BookID = tblCopies.BookID) ON Table1.ISBN =
tblBookDetails.ISBN SET tblCopies.TotalCost = [tblPrices]![UnitPrice];