?????????????????????????????????Ч??????5??????40W+??????????????δ???20????????????????????????????:
????1??????????????????????????????????????????????????ζ?Щ????????????????????????????????????????????????
????2?????????????????????????????????е??????????????????????????????????????????????????????????????????????????????????????￡?
1 SELECT * FROM (
2        SELECT * FROM M_RK_JBXX A
3        LEFT JOIN M_RK_ZFGX B ON A.RKID = B.RKID
4        LEFT JOIN(SELECT *
5            FROM M_DZ_MP D
6            LEFT JOIN M_DZ_LD E ON D.LDID = E.LDID
7            ORDER BY E.XC?? E.PXH?? D.PXH)DD ON B.MPID = DD.MPID
8        LEFT JOIN  M_DZ_WGGL F  ON DD.WGID = F.WGID
9        LEFT  JOIN M_RK_HJXXZH C ON C.MPID = DD.MPID
10 )