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

SELECT b1.bookid, b1.book_type, b1.publisher, b1.author, b1.book_name, b1.price FROM book01 b1 INNER JOIN book01 b2 ON b1.book_name = b2.book_name AND b1.publisher = b2.publisher AND b1.bookid <> b2.bookid ORDER BY b1.publisher, b1.book_name, b1.bookid