select ... from a left outer join (select xxx from tabA inner join tabB on tabA.xxx=tabB.yyy) b on a.sss = b.ttt大概结构就是这样的
