MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TABLE_ID(id int, Status int);
INSERT INTO TABLE_ID(id, Status) VALUES
(100, 1), (200, 1), (300, 0), (400, 0), (500, 1);
SELECT * FROM TABLE_ID;

Records: 5  Duplicates: 0  Warnings: 0

id
Status

100
1

200
1

300
0

400
0

500
1

CREATE TABLE TABLE_A(id int, val VARCHAR(10));
INSERT INTO TABLE_A(id, val) VALUES
(100, 'val1'), (300, 'val2'), (500, 'val3');
SELECT * FROM TABLE_A;

Records: 3  Duplicates: 0  Warnings: 0

id
val

100
val1

300
val2

500
val3

CREATE TABLE TABLE_B(id int, val VARCHAR(10));
INSERT INTO TABLE_B(id, val) VALUES
(300, 'val4'), (400, 'val5'), (500, 'val6');
SELECT * FROM TABLE_B;

Records: 3  Duplicates: 0  Warnings: 0

id
val

300
val4

400
val5

500
val6

CREATE TABLE TABLE_C(id int, val VARCHAR(10));
INSERT INTO TABLE_C(id, val) VALUES
(100, 'val7'), (200, 'val8'), (500, 'val9');
SELECT * FROM TABLE_C;

Records: 3  Duplicates: 0  Warnings: 0

id
val

100
val7

200
val8

500
val9

DELETE a, b, c
FROM TABLE_ID t
LEFT JOIN TABLE_A a ON a.id = t.id
LEFT JOIN TABLE_B b ON b.id = t.id
LEFT JOIN TABLE_C c ON c.id = t.id
WHERE t.Status = 1;
SELECT * FROM TABLE_A;
SELECT * FROM TABLE_B;
SELECT * FROM TABLE_C;

id
val

300
val2

id
val

300
val4

400
val5

id
val