我想在两个表之间合并。输出应该是来自表A,表B的数据。
SELECT date as Date, COUNT(*) as Transaction, SUM(status=0) as Success
FROM transfer_tx_201503 WHERE time >='00:00:00' AND time <= '$searchterm'
UNION SELECT date as Date, COUNT(*) as Transaction, SUM(status=0) as Success FROM request_tx_201503 WHERE time >='00:00:00' AND time <= '$searchterm' GROUP BY date desc"
我想这样放出来:| 2015-03-23 | 5 | 3 | 4 | 1 |
表transfer_tx_2015中的5和3,表request_tx_2015中的4和1
谢谢
公用字段是日期字段,因此联接应该在该字段上。尝试使用以下SQL:
SELECT t.date as Date, COUNT(*) as Transaction, SUM(t.status=0) as Success, COUNT(*) as Request, SUM(r.status=0) as RequestSuccess
FROM transfer_tx_201503 AS t,request_tx_201503 AS r WHERE t.time >='00:00:00' AND t.time <= '$searchterm' AND t.date=r.date
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句