SELECT SUM(recivedPrincipal) AS 'leiji_invest_sum',COUNT(id) AS 'leiji_count',MAX(repayDate) AS 'lately_gathering_date',a.*,c.*
FROM t_invest v LEFT JOIN
(SELECT investor AS 'inv',SUM(recivedPrincipal+recivedPrincipal) AS 'yishou_sum',SUM(recivedPrincipal) AS 'yishou_principal',
SUM(recivedPrincipal) AS 'yishou_lixi',SUM(recivedFI) AS 'yioverdue_lixi' FROM t_invest WHERE investor=4 AND repayStatus IN (1,2)) a
ON v.investor = a.inv
LEFT JOIN (SELECT investor,SUM(recivedPrincipal+recivedPrincipal) AS 'daishou_sum',SUM(recivedPrincipal) AS 'daishou_principal',
SUM(recivedPrincipal) AS 'lixi',SUM(recivedFI) AS 'overdue_lixi' FROM t_invest WHERE investor=4 AND repayStatus =3 ) c
ON v.investor = c.investor
WHERE v.investor=4 ORDER BY v.investTime DESC 这是原代码,
后台报错是 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT SUM(recivedPrincipal) AS 'leiji_invest_sum',COUNT(id) AS 'leiji_count',MA' at line 1 这是什么原因