Can't say why it doesn't work, but it sure seems like it's a bad thing to
do. There is nothing that guarantees the order of the columns returned from
the " select * " statement. If it did work, you could be ordering by
different columns everytime you ran that SQL statement.

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: Mike Grover [mailto:mike@...]
Sent: Friday, January 25, 2002 8:13 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Order By in a Insert statement?



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?

mike

Yahoo! Groups Sponsor
[]



_____


<http://us.adserver.yahoo.com/l?M=153641.1824646.3335993.1261774/D=egroupmai
l/S=1705007709:HM/A=919353/rand=766513986>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .