Re: Using order by with union

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 15 Oct 1999 17:50:43 GMT
Message-ID: <7u7phj$gcv$3@news.seed.net.tw>

Chris Seline <seline_at_2wrongs.com> wrote in message news:38060D9A.69E16EA7_at_2wrongs.com...
> I have switched from using one table to two for my queries, but I have
> run into a problem using order by
>
> I would like to use this query across two tables
> select word,num from wordtable order by -num;
>
> like this
>
> select word,num from wordtable union select word,num from wordtable2
> order by -num;
>
> but it says that "ORDER BY item must be the number of a SELECT-list
> expression"

[snip]

Hi,
try to use "order by num desc" Received on Fri Oct 15 1999 - 12:50:43 CDT