Oracle SQL语句--查询多个表

1. select info_id,class_id,title,author,readcount,replycount,newreplyman from
   (
         select info_id,class_id,title,author,read_count as readcount,
         (select nvl(count(reply_info_id),0) from fnms_reply_info where fnms_reply_info.info_id =tb1.info_id )
         as replycount,
         (select * from (select fnms_reply_info.truename from fnms_reply_info,fnms_release_info tb2 where  fnms_reply_info.info_id = tb2.info_id  order by fnms_reply_info.create_date desc) where RowNum<=1)
         as newreplyman
        
         from fnms_release_info tb1 where tb1.class_id='100100100'
   )