>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

So much to remember, so little time.