select a.deptid,a.deptname,count(newsid) as newscount
from dept as a,deptnews as b
where a.deptid=b.deptid
group by a.deptid,a.deptname
from dept as a,deptnews as b
where a.deptid=b.deptid
group by a.deptid,a.deptname
from dept as a,deptnews as b
where a.deptid=b.deptid
group by a.deptid,a.deptname
from dept as a,deptnews as b
where a.deptid=b.deptid
group by a.deptid,a.deptname
所得结果即:deptid deptname newscount webtbcount
0001 工程科 20 1
002 设备科 90 2
deptid,
deptname,
(Select Count(*) from deptnews Where deptid=A.deptid) As newscount,
(Select Count(*) from webtv Where deptid=A.deptid) As webtbcount
from dept A