SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE BooksA(

BookID INT,

BookPrice MONEY

);

CREATE TABLE BooksB(

BookID INT,

BookPrice MONEY

);

CREATE TABLE BooksC(

BookID INT,

BookPrice MONEY

);

INSERT INTO BooksA VALUES

(1, 100),

(2, 200),

(3, 100);

INSERT INTO BooksB SELECT * FROM BooksA;

INSERT INTO BooksC SELECT * FROM BooksB;

DECLARE @Price MONEY = 500;

DECLARE @IDs TABLE(ID INT);

BEGIN TRAN

UPDATE BooksA

SET BookPrice = @Price

OUTPUT INSERTED.BookID

INTO @IDs

WHERE BookPrice = 100;

UPDATE BooksB

SET BookPrice = @Price

FROM BooksB BB INNER JOIN @IDs I