Re: order by question.

* Ennio-Sr <nasr.laili@tin.it> [040507, 23:52]:
> * Jose Blanco <blancoj@umich.edu> [040507, 14:28]:
> > This second time I did, see
> >
> > select author, sort_author from itemsbyauthor where sort_author like 'tan%'
> > order by 2;
> >
> Hi Jose,
> have you tried to modify your query as others suggested? i.e.:
>
> --> select author, sort_author from itemsbyauthor where sort_author like
> 'tan%' ORDER BY sort_author;
>        ^^^^^^^^^^^^^^^^^^^^

Oops ... I missed your "order by 2" ... Sorry ;(

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]