Re: about ORDER BY (newbie here)

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 07 Feb 2001 05:14:02 GMT
Message-ID: <uQ4g6.387364$U46.11358796@news1.sttls1.wa.home.com>

sure.
select ... from ... where ... order by x,y Now x and Y have to be unique name s of columns in the result set. If you have a column with the same name in multiple tables then you have to prefix the column name in the order by with the table name. order by a.x, b.y
Jim

<" srcnckpc"@hotmail.com> wrote in message news:3A8081DF.4DC0D074_at_hotmail.com...
> I am trying to join 3 tables and sort the results by two columns. Can
> ORDER BY take two variables, ie, ORDER BY X,Y?
>
> I tried ORDER BY (X,Y) but get the error:
>
> missing right parenthesis
>
>
> Thanks for any suggestions,
> SRC
>
>
>
>
Received on Tue Feb 06 2001 - 23:14:02 CST