A
----------------
id name info
----------------
1 aaa zzzzz
2 bbb xxxxx
3 ccc wwwww+++++++++++++++++++++++B
------------------
id name liuyan
------------------
1 aaa sdfsda
2 aaa sadfsd
3 ccc sasdaf
4 bbb sfasds
5 ccc sfdsfs
6 aaa sdsdfs+++++++++++++++++++++++要这样的查询结果 就是 一个留言表 一个用户信息表 取最新top10留言者的用户信息zzzzz
wwwww
xxxxx
----------------
id name info
----------------
1 aaa zzzzz
2 bbb xxxxx
3 ccc wwwww+++++++++++++++++++++++B
------------------
id name liuyan
------------------
1 aaa sdfsda
2 aaa sadfsd
3 ccc sasdaf
4 bbb sfasds
5 ccc sfdsfs
6 aaa sdsdfs+++++++++++++++++++++++要这样的查询结果 就是 一个留言表 一个用户信息表 取最新top10留言者的用户信息zzzzz
wwwww
xxxxx
FROM B b LEFT OUTER JOIN A a on b.NAME = A.NAME
ORDER BY B.ID DESC
应该是 按B表内最新留言的10个name(重复的不算)取出A表的info
left join (select top 10 distinct name from B ) t2
on t1.name=t2.name
left join (select top 10 distinct name from B order by id desc ) t2
on t1.name=t2.name