一个我感觉比较复杂的问题

[yigeming]

有三个表：blog user bbs

blog表中字段uid ，blogname，pvcount
user中字段 userid ，nickname
bbs表中字段uid、title ，posttime

我现在想建一个试图

查询根据一个userid 显示blogname pvcount 还有就是此用户最后发布的title

[yigeming]

根据pvcount字段排序

[hyde100]

select 
	blogname,
	pvcount,
	title=(select  top 1 title from bbs where bbs.uid=blog.uid order by posttime desc)
from blog
where uid=@userid

[ljhcy99]

Create View MyView As

select blog.blogname,blog.pvcount ,bbs.title
from blog,bbs
(select max(bbs.posttime ) as max_time,bbs.uid as id
from bbs
group by bbs.uid
) AS AA

where blog.uid = bbs.uid
and bbs.uid =AA.id
and bbs. posttime = AA.max_time
and blog.uid in (select userid from user )

[yigeming]

有人吗