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 - 函数声明和匿名函数有什么不同?(前端小白求助。。)2. javascript - 求助关于js正则问题3. JAVASCRIPT 构造函数和原型互相指向问题?求助!!!4. 新手求助!!!5. ueditor上传服务器提示后端配置项没有正常加载,求助!!!!!6. javascript - gulp-babel不能转码数组的fill方法和Object.assign方法?求助7. javascript - 关于向java后台上传base64位字符串的图片数据,求助8. javascript - 求助一个关于indexedDB的问题9. javascript - 求助大问题!!!!!这输出为什么能不一样10. 数据库 - Mysql的存储过程真的是个坑!求助下面的存储过程哪里错啦,实在是找不到哪里的问题了。