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

SELECT b1.[author], b1.[book_name] as [book_name1], b1.[publisher] as [publisher1], b2.[book_name] as [book_name2], b2.[publisher] as [publisher2] FROM [master].[dbo].[book01] b1 INNER JOIN [master].[dbo].[book01] b2 ON b1.[author] = b2.[author] AND b1.[bookid] <> b2.[bookid]