""Mike Grover"" <mike@...> wrote in message
news:NCBBILCEMLDCJOMKGJJKOEPDEHAA.mike@......

> I need to do a select on one table and insert the records into another
> in a particular order.
>
> the second table is a external Table.

You either write a small stored procedure or use IB6.5's ORDER BY but
coupled with the ROWS feature, it seems that it works.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing