这个查询怎么写？

这个查询怎么写？
表a
   id    inID    out ID
    1    1         null
    2     2        1
表a_D
   id    inNum  inID
   1     I0001     1
   2     I0002     2

表b  
     id      OutID   
     1          1
表b_D
    id       OutNum  OutID
     1        O0001          1

我要得到的是
InNum   OutNum
I0001      null
I0002      O0001

表a
   id    inID    Out_ID   inName
    1    1         null          one
    2     2        1               two
表a_D
   id    inNum  inID
   1     I0001     1
   2     I0002     2

表b  
     b_id      OutID    OutName
     1          1           one
表b_D
    id       OutNum  b_id
     1        O0001          1

我要得到的是
InNum   OutNum    InName
I0001      null              one
I0002      O0001         two

SELECT a_D.inNum, b_D.OutNum, a.inName
FROM b INNER JOIN ((a INNER JOIN a_D ON a.id = a_D.id) INNER JOIN b_D ON a.id = b_D.id) ON b.b_id = b_D.b_id

谢谢 XieLi真的非常感谢
按照你的思路 我把它写出来了
select W.MTRIn_Num,W.AB_Remark,W.MTROut_Num
from (select E.AB_Remark,E.AO_ID,E.MTRIn_Num,F.MTROut_Num from
(select a.AB_Remark,a.AO_ID,b.MTRIn_Num from AnotherBack a left join MTR_In b on a.MTRIn_ID=b.MTRIn_ID) E
left join (select c.MTROut_Num ,d.AO_ID from MTROut c left join AnotherOut d on c.MTROut_ID=d.MTROut_ID ) F on E.AO_ID=F.AO_ID ) W