[RESOLVED] SELECT ... INSERT statement

[perpetualshaun]

I am trying to write a query to duplicate an order in our eCommerce application here. I could have sworn I wrote a query JUST like this before and it worked, but for some reason this is not working. My query looks like this:

SELECT 1141139101, orig_cart_ordr_hdr.ordr_po_num, orig_cart_ordr_hdr.ordr_requested_date ...
FROM cart_ordr_hdr AS orig_cart_ordr_hdr
WHERE orig_cart_ordr_hdr.ordr_id=33
INSERT INTO cart_ordr_hdr (ordr_received_on, ordr_po_num, ordr_requested_date, ...)

There are about 50 fields in the query, but I just listed a few in my snippet of the query here. We're running MySQL 4.1.7 on this server. Any ideas?

Thanx,
Shaun

[Lars_Berg]

You have the clauses in wrong order

insert into ... select ...