请教一条oracle 的sql语句

Question

现在有两张表 
版块表 JFORUM_FORUMS FORUM_ID（版块主键）  FORUM_NAME(版块名称)  
JFORUM_TOPICS 帖子表
TOPIC_ID（帖子主键）  FORUM_ID（版块id） 
我现在想查询出            所有版块当天发帖的数量   例如： 
电子银行  4
鑫意理财 6
开放式基金 121自己写了一条sql   select JFORUM_FORUMS.FORUM_NAME ,JFORUM_FORUMS.forum_desc, A2.numb from 
( select count(*) as numb,JFORUM_TOPICS.FORUM_ID
from JFORUM_TOPICS where TO_CHAr(TOPIC_TIME,'yyyy-mm-dd')=TO_CHAr(sysdate,'yyyy-mm-dd') group by     JFORUM_TOPICS.FORUM_ID)
  A2,JFORUM_FORUMS
 where A2.FORUM_ID=JFORUM_FORUMS.FORUM_ID
只能查询出  今天发帖的数量和版块名称  
而没有得到 所有版块名称 和 当天发帖的数量 求各位帮忙完善下     

Answer 1

select jf.forum_name,count(jt.topic_id)
from JFORUM_FORUMS jf,JFORUM_TOPICS jt
where jf.forum_id=jt.forum_id
and TOPIC_TIME=sysdate
group by jf.forum_name

Answer 2

select JFORUM_FORUMS.FORUM_NAME ,JFORUM_FORUMS.forum_desc, 
  nvl( A2.numb , 0 ) numb
from 
    ( select count(*) as numb,JFORUM_TOPICS.FORUM_ID
    from JFORUM_TOPICS where TO_CHAr(TOPIC_TIME,'yyyy-mm-dd')=TO_CHAr(sysdate,'yyyy-mm-dd') group by     JFORUM_TOPICS.FORUM_ID)
  A2,JFORUM_FORUMS
 where A2.FORUM_ID(+) = JFORUM_FORUMS.FORUM_ID

Answer 3

select JFORUM_FORUMS.FORUM_NAME ,JFORUM_FORUMS.forum_desc, A2.numb from 
    ( select count(*) as numb,JFORUM_TOPICS.FORUM_ID
    from JFORUM_TOPICS where TO_CHAr(TOPIC_TIME,'yyyy-mm-dd')=TO_CHAr(sysdate,'yyyy-mm-dd') group by     JFORUM_TOPICS.FORUM_ID)
  A2,JFORUM_FORUMS
 where A2.FORUM_ID(+)=JFORUM_FORUMS.FORUM_ID