SELECT DISTINCT TitleAndAuthor.AuthorNo, Author.AuthorNo, Author.AuthorName FROM TitleAndAuthor LEFT JOIN Author ON TitleAndAuthor.AuthorNo = Author.AuthorNo ORDER BY Author.AuthorName