CREATE TABLE IF NOT EXISTS A ( ID INT, APROBADO TINYINT, REVISADO TINYINT );
CREATE TABLE IF NOT EXISTS B ( ID INT, APROBADO TINYINT, REVISADO TINYINT );
CREATE TABLE IF NOT EXISTS C ( ID INT, APROBADO TINYINT, REVISADO TINYINT );

INSERT INTO A VALUES
(1,0,0),
(2,0,1),
(3,0,0),
(4,0,1);

INSERT INTO B VALUES
(10,0,0),
(11,0,0),
(12,0,1),
(13,0,0);

INSERT INTO C VALUES
(21,0,0),
(22,0,0),
(23,0,0),
(24,0,1);

--intento 1
UPDATE A,B,C SET A.APROBADO = A.REVISADO, B.APROBADO = B.REVISADO, C.APROBADO = C.REVISADO;
--intento 2
UPDATE A JOIN B JOIN C SET A.APROBADO = A.REVISADO, B.APROBADO = B.REVISADO, C.APROBADO = C.REVISADO;
--intento 3
UPDATE A                            INNER JOIN
       B ON B.REVISADO = A.REVISADO INNER JOIN
       C ON C.REVISADO = A.REVISADO
SET A.APROBADO = A.REVISADO,
    B.APROBADO = B.REVISADO,
    C.APROBADO = C.REVISADO;