SELECT TitleAndAuthor.AuthorNo, TitleAndAuthor.TitleNo, Author.AuthorName, Author.AuthorNo FROM TitleAndAuthor LEFT JOIN Author ON TitleAndAuthor.AuthorNo=Author.AuthorNo WHERE TitleNo = #TitleNo# ORDER BY Author.AuthorName