Re: Unload vs. Insert into

Because the relational paradigm does not include the concept of "ordering" in a table - so inserting data in a particular order make no sense. See "An Introduction to Database Systems", by C. J. Date, sixth edition, pages 91 -93: Properties of Relations: tuples are unordered, top to bottom. To depend on a select to fetch the tuples in the same order that you inserted them is a mistake. Its not guaranteed. "Pachiano, Vince" wrote: > Here is the SQL command I was --trying-- to use > > insert into B select * from A order by C> > Too Bad this is invalid (05.0x SE) > the "order by" is not supported. > > Instead, I can use the round-about method: > > unload to F select * from A order by C > load from F insert into B> > My question, is WHY?