四表嵌套查询的sql语句

四表嵌套查询的SQL语句如下所示：

SELECT *
FROM table1
WHERE column1 IN (
SELECT column2
FROM table2
WHERE column3 IN (
SELECT column4
FROM table3
WHERE column5 IN (
SELECT column6
FROM table4
WHERE column7 = 'value'
)
)
);