mysql連表統計查詢問題,求助
問題描述
問題解答
回答1:select u2.username as borrower,u1.username as debtor,sum(b.amount) as debt from borrow_log b left join users u1 on b.debtor = u1.id left join users u2 on b.borrower = u2.id where u1.gender = 1 group by b.borrower,b.debtor;回答2:
SELECT (SELECT us.username FROM users us WHERE us.id=a.borrow) AS borrow_name, (SELECT us.username FROM users us WHERE us.id=a.debtor) AS debtor_name, SUM(amount) AS total_amount FROM borrow_log a LEFT JOIN users b ON a.debtor = b.id WHERE b.gender = 1 GROUP BY a.borrow,a.debtor回答3:
SELECT a1.*,a2.username AS debname,a3.username AS borrowname,SUM(a1.amount) FROM a1 LEFT JOIN a2 ON a1.debtor=a2.id LEFT JOIN a2 AS a3 ON a1.borrower=a3.id WHERE a2.gender=1 GROUP BY a1.debtor ,a1.borrower
相關文章:
1. javascript - 求助關于call和apply的問題,反柯里化2. javascript - 關于addEventListener和attachEvent的兼容寫法疑問,求助!3. 求助一個Android控件名稱4. python在list相加 求助5. 請問怎么點擊背景,藍色變紅色,紅色變藍色呢?我代碼哪里出錯了嗎?求助,謝謝6. list - python 求助7. javascript - 函數聲明和匿名函數有什么不同?(前端小白求助。。)8. python - 求助,ValueError: View function did not return a response9. angular.js - angular post的Content-Type被設置,導致不能上傳圖片,求助!!10. ueditor上傳服務器提示后端配置項沒有正常加載,求助!!!!!
