mysql - 我怎样才能整理这个 MySQL 代码并使其更具可读性？

Question

SELECT
    *
FROM
    `table_1`
WHERE
    `id` = 
            (
                SELECT 
                    `an_id` 
                FROM
                    `table_2` 
                WHERE
                    `id` = 
                            (
                                SELECT 
                                    `another_id` 
                                FROM 
                                    `table_3`
                                WHERE 
                                    `id` = 
                                            (
                                                SELECT                      
                                                    `yet_another_id` 
                                                FROM 
                                                    `table_4` 
                                                WHERE 
                                                    `id` = 123
                                            )
                            )
            )

很丑吧？
我想我可以在这里使用 JOIN - 但如何使用？

Answer 1

select t1.*
from
    table1 t1,
    table2 t2,
    table3 t3,
    table4 t4
where
    t4.id = 123
    and t3.id = t4.yet_another_id
    and t2.id = t3.another_id
    and t1.id = an_id;