怎么查找重复记录？

koutx

SELECT b.学校, b.姓名
FROM b
WHERE (((b.学校)="A") AND ((b.姓名) In (SELECT [姓名] FROM As Tmp GROUP BY [姓名] HAVING Count(*)>1 )))
ORDER BY b.姓名;

koutx

Where子句中的From后加上即可。
不知怎么搞的，总也添不上它，添上后一上传它就又没了。

以下是查询结果：

koutx

Where子句中From后加[b]