再来个语句,请高手帮忙简化,呵呵
SELECT name,
(SELECT COUNT(id)
FROM userinfo
WHERE politics = a.id AND id IN
(SELECT id
FROM student
WHERE class IN
(SELECT id
FROM class
WHERE f_grade_id = 1))) AS todal
FROM dbo.basicmess A
WHERE (type = 7)
[解决办法]
try
SELECT A.name,
COUNT(E.id) AS todal
FROM dbo.basicmess A
Left Join
(Select B.id, B.politics From userinfo B
Inner Join student C On B.id = C.id
Inner Join class D On C.class = D.id
Where D.f_grade_id = 1) E
On A.id = E.politics
WHERE (A.type = 7)
Group By A.name
