select b.*,E.*,F.*,G.* from B left join E on B.id = E.id left join F on B.id = F.id left join G on B.id = G.id
from a inner join b on a.X=b.X. left join c on a.Y = c.Y left join d on a.Z = d.Z left join e on b.M = e.M left join F on b.N = e.N left join G on b.O = e.O
这个里面就没有A表的关联关系了 - - A B C D E F G 这几个表是一个查询写出来的 = =|
left join E on B.id = E.id
left join F on B.id = F.id
left join G on B.id = G.id
left join c on a.Y = c.Y
left join d on a.Z = d.Z
left join e on b.M = e.M
left join F on b.N = e.N
left join G on b.O = e.O
这个里面就没有A表的关联关系了 - -
A B C D E F G 这几个表是一个查询写出来的 = =|