我有2個表需要根據日期和2值加在一起.

這給了我所有信息的清單 – 罰款.

$query = (SELECT date, debit, credit , note FROM proj3_cash )

UNION

(SELECT settle, purch, sale, issue FROM proj3_trades)

ORDER BY date";

現在我需要從兩個表中分組每日總計的信息.

$query = "(SELECT date, SUM(debit), SUM(credit)FROM proj3_cash GROUP BY date)

UNION

(SELECT settle as date, SUM(purch) as debit, SUM(sale) as credit FROM proj3_trades GROUP BY date)

ORDER BY date";

好的,但是如果每張表中的日期相同,我得到：

date SUM(debit) SUM(credit)

--------------------------------------

2010-12-02 0.00 170.02

2010-12-02 296449.91 233111.10

如何將兩人分成同一天？

如果我最后添加GROUP BY – 我只收到一個錯誤.還是應該用JOIN來完成？

總結

以上是生活随笔為你收集整理的mysql union group by_Mysql UNION和GROUP BY的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。