高手帮看下，新手不会写SQL
SELECT A.ID,A.Name,
(SELECT COUNT(B.ID) FROM Doc_List B WHERE B.Doctype = A.ID AND B.PrjID=2) As DocCount
FROM Doc_Type A
Where (SELECT COUNT(B.ID) As DocCount FROM Doc_List B WHERE B.Doctype = A.ID AND B.PrjID=2)> 0
ORDER BY A.ID
这据SQL能执行，但感觉是不是重复了，效率低下，高手指教下应该怎么写！谢谢！
[解决办法]
select
A.ID,A.Name,COUNT(B.ID) as DocCount
from
Doc_Type A,
Doc_List B
where
B.Doctype = A.ID and B.PrjID=2
group by
A.ID,A.Name
