真的骄傲梦想家园
专业源于兴趣和努力
摘要: 1 SELECT c.*, sum(t.num) as num, b.num as total FROM np_wenjuan_choice as c 2 left join ( 3 select content, count(id) as num 4 from np_wenjuan_answer as a 5 where question_id = 8 6 group by content 7 ) as t on t.content like concat('%',c.index,'%') 8 left join ( 9 select question_id, 阅读全文
posted @ 2012-07-07 14:40 真的骄傲 阅读(309) 评论(0) 推荐(0) 编辑