SQL查询同一作者不同出版社出版的图书

SELECT b1.[bookid], b1.[book_type], b1.[publisher] AS publisher1, b1.[author], b1.[book_name], b1.[price], b2.[publisher] AS publisher2 FROM [master].[dbo].[book01] b1 JOIN [master].[dbo].[book01] b2 ON b1.[author] = b2.[author] AND b1.[book_name] = b2.[book_name] AND b1.[publisher] <> b2.[publisher] ORDER BY b1.[author], b1.[book_name]