从深度嵌套的 mySQL 查询中选择多个列

Question

select 
    a 
from 
    table_1 
where 
    b in ( 
       select 
           c 
       from 
           table_c 
       where 
           d in ( 
              select 
                 e 
              from 
                 table_e 
           )
      );

我也想在最终结果中传递"d"....无论如何？

Answer 1

你需要使用JOIN：

select 
    a ,
    d
from 
    table_1 
inner join table_c
    ON b = c
inner join table_e
    ON d = e