请帮找错 晕大了
$sql="SELECT * FROM (
SELECT newday,ulname1 SUM(newcharge) AS new_charge FROM (
SELECT date_format(check_end_date,'".$x."') AS newday ,SUM(a.user_charge+0) AS newcharge,user_login_name as ulname1 FROM table1 a GROUP BY date_format(check_end_date,'".$x."')
UNION ALL
SELECT date_format(user_login_time,'".$x."') ,SUM(a.user_charge+0) FROM table2 a GROUP BY date_format(user_login_time,'".$x."')) a GROUP BY newday
) a1
LEFT JOIN
(SELECT user_zone_group as uzg,user_login_name as ulname2,user_group_id as ugid FROM tab1 ) a2
ON a1.ulname=a2.ulname2
LEFT JOIN
(SELECT user_group_id as ugid2 FROM tab12 ) a3
ON a2.ugid=a3.ugid2
UNION ALL
SELECT DISTINCT 'total',
(SELECT SUM(newcharge) AS new_charge FROM (
SELECT date_format(check_end_date,'".$x."') AS newday ,SUM(a.user_charge+0) AS newcharge FROM table1 a GROUP BY date_format(check_end_date,'".$x."')
UNION ALL
SELECT date_format(user_login_time,'".$x."'),SUM(a.user_charge+0) FROM table2 a GROUP BY date_format(user_login_time,'".$x."'))
a)s2 FROM s2 ORDER BY newday DESC";
[解决办法]
什么错误？ 错误提示是什么？
