21,887
社区成员
发帖
与我相关
我的任务
分享
SELECT
*
FROM
a
LEFT JOIN b ON a.id = b.a_id
LEFT JOIN c ON a.id = c.aa_id
LEFT JOIN d ON b.id = d.b_id
LEFT JOIN e ON b.id = e.b_id
LEFT JOIN f ON a.f_id = f.id
SELECT
*
FROM
(select * from a LEFT JOIN (b, c, f) ON (a.id = b.a_id and a.id = c.aa_id and a.f_id = f.id)) t1
LEFT JOIN
(select * from b LEFT JOIN (d, e) ON (b.id = d.b_id and b.id = e.b_id) t2
ON t1.id = t2.a_id