一条sql
现在有2张表 T1 T2
t1:
questionID questionText 
1 1
2 2
3 3

t2:
questionID UserID
1 1
1 2
1 3
2 1
2 4

我先现在如何得到这样的数据

questionID questionText COUNTS
1 1 3
2 2 2
3 3 0

谢谢~


------解决方案--------------------

探讨

SQL code
select a.questionID，a.questionText COUNTS=count(b.questionID)
from t1 a left join t2 b
on a.questionID =b.questionID