22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM tab1
LEFT JOIN tab2
ON tab1.AID = tab2.AID
LEFT JOIN tab3
ON tab3.BID = tab1.BID
INNER JOIN tab4
ON tab4.WID = tab1.WID
LEFT JOIN tab5 a
ON a.TypeID = 9
AND tab1.SID = a.ID
LEFT JOIN tab15 b
ON b.TypeID = 7
AND tab1.Age = b.ID