"Lucas" <Lucas_44_at_hotmail.com> wrote in message
news:8soh9.3868$pa1.437731_at_news0.telusplanet.net...
> Hi all,
>
> I want my query result to be in the same order as my codes that I set:
>
> Ex:
>
> select * from
> Emp
> where empcode in (810,974,603,648)
>
> The result is not at all in this order? Any suggestions on why? Or is
there
> a better way of doing this?
>
>
> Lucas
>
>
In your SQL, specify ORDER BY for the order you want.
If that doesn't answer the question, there's something wrong with your
database design.
HTH,
Paul
Received on Sun Sep 22 2002 - 14:50:13 CDT
