如何缩短这条sql语句？(3个子查询)

SELECT column1, column2
FROM table1
WHERE column3 IN (SELECT column4 FROM table2 WHERE condition1)
AND column5 IN (SELECT column6 FROM table3 WHERE condition2)
AND column7 IN (SELECT column8 FROM table4 WHERE condition3);

SELECT t1.column1, t1.column2
FROM table1 t1
JOIN table2 t2 ON t1.column3 = t2.column4
JOIN table3 t3 ON t1.column5 = t3.column6
JOIN table4 t4 ON t1.column7 = t4.column8
WHERE condition1 AND condition2 AND condition3;