mysql 关联sql

<pre name="code" class="sql">SELECT     *FROM    DWF.F_EVT_EXTR_FINANCE_BOOK a        LEFT JOIN    dwf.f_extc_finance_para b ON a.product_no = b.product_no        LEFT JOIN    dwm.b_m_sys_branch c ON a.SIGN_ORG = c.org_idSELECT     c.userNick, a.status, b.name, d.investBalance, a.otherinfoFROM    ClientCoupon a        LEFT JOIN    Coupon b ON a.couponSn = b.sn        LEFT JOIN    Client c ON a.Clientsn = c.sn        LEFT JOIN    (SELECT         clientSn, SUM(investBalance) AS investBalance    FROM        ClientInvestOrder    WHERE        createdTime >= '2015-11-11 00:00:00'            AND createdTime <= '2015-11-13 23:59:59'    GROUP BY clientSn) d ON c.sn = d.clientSnWHERE    a.clientSn IS NOT NULLORDER BY c.userNick