SQL 查询同一出版社出版的同名图书

SELECT [bookid], [book_type], [publisher], [author], [book_name], [price] FROM [master].[dbo].[book01] WHERE [publisher] IN ( SELECT [publisher] FROM [master].[dbo].[book01] GROUP BY [publisher], [book_name] HAVING COUNT() > 1 ) AND [book_name] IN ( SELECT [book_name] FROM [master].[dbo].[book01] GROUP BY [publisher], [book_name] HAVING COUNT() > 1 ) ORDER BY [publisher], [book_name]