select b.code_name,count(*) from question ab join code a on a.code_type='问题代码' and a.code_name='对处理结果是否满意' and a.code_id=ab.question_id join code b on b.code_type='答案代码' and b.code_id=ab.answer_id group by b.code_name
谢谢 zjcxc(邹建) skyboy0720(飞) : 我的第一题是指:对处理结果是否满意
Select t2.code_name, Count(t1.Answer_id) Where Question_id = 1 Group by t2.Code_name, t1.Answer_id
from question ab
join code a on a.code_type='问题代码'
and a.code_name='对处理结果是否满意'
and a.code_id=ab.question_id
join code b on b.code_type='答案代码'
and b.code_id=ab.answer_id
group by b.code_name
skyboy0720(飞) : 我的第一题是指:对处理结果是否满意
Count(t1.Answer_id)
Where Question_id = 1
Group by t2.Code_name, t1.Answer_id