Re: Unable to use ORDER BY in an INSERT statement

Dave Lumby wrote:
>
> Folks,
> I'm trying to transfer fields from one table to another in a specific
> order. Ideally I'd like to be able to use a statement something like -
 

> INSERT INTO new_table (user_ref, start, rec_id) VALUES ('654321', '07:30', 1);
> INSERT INTO new_table (user_ref, start, rec_id) VALUES ('400000', '07:30', 2);
> etc

Would the following do what you want?
CREATE SEQUENCE seq;

INSERT INTO new_table (user_ref, start, revc_id>   SELECT bt.account_no, '07:30', seq.NEXTVAL   FROM big_table bt
  WHERE bt.filter = 1;

 DROP SEQUENCE seq;

> Thanks for taking the time to read this and for any help to may be able to
> offer.
>
> Dave

-- 
===============================================================
Sukhvinder Aujla	Tel: 01473 647640     Fax:01473 640279
Address: MLB5/51, BT Labs, Martlesham Heath, Ipswich IP5 7RE
email: saujla_at_axion.bt.co.uk