Re: Problem with simple SQL query!

From: Tom Sager <tom.sager_at_lgeenergy.com>
Date: 1998/09/30
Message-ID: <MPvQ1.3417$rm3.2059206779@news.ntr.net>#1/1

<<When I remove the ORDER part of the statement it runs fine but the ORDER is essential. Can anyone help on this one?>>

This is because an ORDER clause is not valid in a subquery. Why is order important to you? Your statement is merely inserting rows into a table. The order in which rows are inserted into a table hasn't much significance. The order in which you insert rows does not guarantee the order in which they will be retrieved.

When you are ready to SELECT rows from the inserted table, you can order them any way you want with an ORDER BY. Received on Wed Sep 30 1998 - 00:00:00 CDT