SELECT Title.TitleName, Title.Imprint, Title.TitleNo, Title.FourLetter, Title.Directory, TitleAndGenre.TitleNo, TitleAndGenre.GenreNo FROM TitleAndGenre LEFT JOIN Title ON TitleAndGenre.TitleNo=Title.TitleNo WHERE TitleAndGenre.GenreNo = #URL.GenreNo# ORDER BY Title.TitleName