SELECT * FROM table_1 WHERE X1 IN (SELECT x2 FROM table_2 UNION SELECT x3 FROM table_3 UNION SELECT x4 FROM table_4);