select * from (select USERNAME,NICK_NAME from usertable where `LEVEL` =1) u Left JOIN (select a.`Name` ,
MAX(CASE a.`month` WHEN CONCAT('2017','-','04') THEN a.sumF ELSE 0 END) 'Apr',
MAX(CASE a.`month` WHEN CONCAT('2017','-','05') THEN a.sumF ELSE 0 END) 'May',
MAX(CASE a.`month` WHEN CONCAT('2017','-','06') THEN a.sumF ELSE 0 END) 'Jun',
MAX(CASE a.`month` WHEN CONCAT('2017','-','07') THEN a.sumF ELSE 0 END) 'Jul',
MAX(CASE a.`month` WHEN CONCAT('2017','-','08') THEN a.sumF ELSE 0 END) 'Aug',
MAX(CASE a.`month` WHEN CONCAT('2017','-','09') THEN a.sumF ELSE 0 END) 'Sep',
MAX(CASE a.`month` WHEN CONCAT('2017','-','10') THEN a.sumF ELSE 0 END) 'Oct',
MAX(CASE a.`month` WHEN CONCAT('2017','-','11') THEN a.sumF ELSE 0 END) 'Nov',
MAX(CASE a.`month` WHEN CONCAT('2017','-','12') THEN a.sumF ELSE 0 END) 'Dec',
MAX(CASE a.`month` WHEN CONCAT('2018','-','01') THEN a.sumF ELSE 0 END) 'Jan',
MAX(CASE a.`month` WHEN CONCAT('2018','-','02') THEN a.sumF ELSE 0 END) 'Feb',
MAX(CASE a.`month` WHEN CONCAT('2018','-','03') THEN a.sumF ELSE 0 END) 'Mar'
from (select `Name`,SUM(K) as sumF,UpdateTime as `month` from manager where UpdateTime BETWEEN '2017-04' and '2018-03' and (A='通常') GROUP BY `Name`, UpdateTime) a GROUP BY a.`Name`) k
on k.`Name` = u.USERNAME thinkphp连接实在是没看懂
MAX(CASE a.`month` WHEN CONCAT('2017','-','04') THEN a.sumF ELSE 0 END) 'Apr',
MAX(CASE a.`month` WHEN CONCAT('2017','-','05') THEN a.sumF ELSE 0 END) 'May',
MAX(CASE a.`month` WHEN CONCAT('2017','-','06') THEN a.sumF ELSE 0 END) 'Jun',
MAX(CASE a.`month` WHEN CONCAT('2017','-','07') THEN a.sumF ELSE 0 END) 'Jul',
MAX(CASE a.`month` WHEN CONCAT('2017','-','08') THEN a.sumF ELSE 0 END) 'Aug',
MAX(CASE a.`month` WHEN CONCAT('2017','-','09') THEN a.sumF ELSE 0 END) 'Sep',
MAX(CASE a.`month` WHEN CONCAT('2017','-','10') THEN a.sumF ELSE 0 END) 'Oct',
MAX(CASE a.`month` WHEN CONCAT('2017','-','11') THEN a.sumF ELSE 0 END) 'Nov',
MAX(CASE a.`month` WHEN CONCAT('2017','-','12') THEN a.sumF ELSE 0 END) 'Dec',
MAX(CASE a.`month` WHEN CONCAT('2018','-','01') THEN a.sumF ELSE 0 END) 'Jan',
MAX(CASE a.`month` WHEN CONCAT('2018','-','02') THEN a.sumF ELSE 0 END) 'Feb',
MAX(CASE a.`month` WHEN CONCAT('2018','-','03') THEN a.sumF ELSE 0 END) 'Mar'
from (select `Name`,SUM(K) as sumF,UpdateTime as `month` from manager where UpdateTime BETWEEN '2017-04' and '2018-03' and (A='通常') GROUP BY `Name`, UpdateTime) a GROUP BY a.`Name`) k
on k.`Name` = u.USERNAME thinkphp连接实在是没看懂
解决方案 »
- imagecolortransparent 处理后图片效果 不纯洁
- mysql插入大量数据的效率问题
- 假设image.jpg在服务器上是存在的,而且PHP可以读取它。那么这段代码执行以后的结果是什么呢?
- ShopEX 充值出现“本项必填”但是实际却是填写了
- js 检测checkbox
- php 多条件 分页查询条件丢失 怎么解决啊? 跪求高手,网上找了几天了,自己实验了好久,就是弄不好哦.
- 如何用最佳办法判断数据库连接是否正确,然后报出什么错误?
- 请教高手一个发送邮件的问题?谢谢!!!!!!!!!!!!!!!!!!!!!!!
- 有谁做过预约挂号医生排班的程序,给个思路。
- 动态添加表单并提交数据。
- 怎么把easyphp的项目放到阿里云服务器上
- Curl问题: unable to get local issuer certificate Response Status
反倒是你的 SQL 指令写的实在让人费解
MAX(CASE a.`month` WHEN CONCAT('2017','-','04') THEN a.sumF ELSE 0 END) 'Apr',
MAX(CASE a.`month` WHEN CONCAT('2017','-','05') THEN a.sumF ELSE 0 END) 'May',
MAX(CASE a.`month` WHEN CONCAT('2017','-','06') THEN a.sumF ELSE 0 END) 'Jun',
MAX(CASE a.`month` WHEN CONCAT('2017','-','07') THEN a.sumF ELSE 0 END) 'Jul',
MAX(CASE a.`month` WHEN CONCAT('2017','-','08') THEN a.sumF ELSE 0 END) 'Aug',
MAX(CASE a.`month` WHEN CONCAT('2017','-','09') THEN a.sumF ELSE 0 END) 'Sep',
MAX(CASE a.`month` WHEN CONCAT('2017','-','10') THEN a.sumF ELSE 0 END) 'Oct',
MAX(CASE a.`month` WHEN CONCAT('2017','-','11') THEN a.sumF ELSE 0 END) 'Nov',
MAX(CASE a.`month` WHEN CONCAT('2017','-','12') THEN a.sumF ELSE 0 END) 'Dec',
MAX(CASE a.`month` WHEN CONCAT('2018','-','01') THEN a.sumF ELSE 0 END) 'Jan',
MAX(CASE a.`month` WHEN CONCAT('2018','-','02') THEN a.sumF ELSE 0 END) 'Feb',
MAX(CASE a.`month` WHEN CONCAT('2018','-','03') THEN a.sumF ELSE 0 END) 'Mar'这种就交给PHP去做就好了