56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT 姓名
,sum(if(定性='一般',1,0)) as 一般
,sum(if(定性='严重',1,0)) as 严重
,sum(if(定性='规范',1,0)) as 规范
,sum(if(定性='建议',1,0)) as 建议
from 表1, 表3
where 表1.YID=表3.RYID
group by 姓名
SELECT ryid
,sum(if(wtdx='一般',1,0)) as 一般
,sum(if(wtdx='严重',1,0)) as 严重
,sum(if(wtdx='规范',1,0)) as 规范
,sum(if(wtdx='建议',1,0)) as 建议
from 表3
group by ryid
select 姓名,b.* from 表1 a left join (SELECT ryid
,sum(if(wtdx='一般',1,0)) as 一般
,sum(if(wtdx='严重',1,0)) as 严重
,sum(if(wtdx='规范',1,0)) as 规范
,sum(if(wtdx='建议',1,0)) as 建议
from 表3
group by ryid) b on a.ryid = b.ryid
无记录的是null,自己用ifnull处理,懒得打了。