The columns being sorted on only have to be in the column list if there is a group by in the query. The following works fine:

select au_lname from authors order by au_fname

-Mike