select classname,isnull((select count(id) From news Where news.classid=newsclass.id),0) as scount From newsclass
select c.UnitID, c.UnitName, COUNT(*)AS 'count' from Article AS a INNER JOIN Login AS b ON a.LoginID = b.LoginID AND b.Judg= ''INNER JOIN t_Unit AS c ON b.UnitID = c.UnitID AND a.Audit = 'T' GROUP BY c.UnitID, c.UnitName已经统计出来了,不过只显示有文章的 不显示没文章;没文章的怎么显示0?
from Article AS a INNER JOIN Login AS b ON a.LoginID = b.LoginID AND b.Judg= ''INNER JOIN
t_Unit AS c ON b.UnitID = c.UnitID AND a.Audit = 'T'
GROUP BY c.UnitID, c.UnitName已经统计出来了,不过只显示有文章的 不显示没文章;没文章的怎么显示0?
==>
left outer join
浪费感情,害的我前面猜了半天,早贴代码。用left join。多了解下left join,right join,inner join。
原本统计到没有文章就是显示0啊sql="select count(id) from 表"