to 17楼
看我16楼的解释
看我16楼的解释
曾经有双翅膀，我没用她飞上蓝天，丢锅里炖汤了！
谢谢 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