联合查询怎么样select count?

[yeahx]

select a.title, a.creator,a.hits,a.status,
(select datediff(Hour,b.createdtime,getdate())) as issuetime from table1 a
left join table2 b
on a.questionid=b.questionid
where a.status='A07'

假设上面的sql语句查出来的是四条纪录,那怎么样select count,试了好久都不行

[vicqqq]

select @@RowCount