Re: Problem with simple SQL query!

From: Tom Sager <tom.sager_at_lgeenergy.com>
Date: 1998/09/30
Message-ID: <MPvQ1.3417$rm3.2059206779_at_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 CEST

This message: [ Message body ]
Next message: Rino d'Agostino: "HELP ME - connection to a local Access database using Oracle DISCOVERER/2000"
Previous message: John Durst: "Re: Problem with simple SQL query!"
In reply to: Terry Maguire: "Problem with simple SQL query!"
Next in thread: Terry Maguire: "Re: Problem with a simple SQL query!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message