Re: order by question.

* Ennio-Sr <nasr(dot)laili(at)tin(dot)it> [040507, 23:52]:
> * Jose Blanco <blancoj(at)umich(dot)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) ]