At 01/25/2002 10:12 AM (Friday), Mike Grover wrote:

>This SQL Statemnet works Good:
>INSERT INTO MG
>SELECT *
>FROM KS WHERE ZIP='66873';
>
>But this Doesn't:
>INSERT INTO MG
>SELECT *
>FROM KS WHERE ZIP='66873' ORDER BY 3;
>
>Is this not allowed?

There is a good chance this is not allowed since according to long
established RDBMS principles the order records are in a table is not
significant. According to that principle the order that the records are
obtained from the source table is irrelevant if they are just being
inserted into another table. I'm sure you can order the records later when
they are subsequently selected from the destination table.

Why is it you want this to work?