mysql query

[garfx]

please help

i am trying to copy from columns "export_price , dotshop_price , territory_id" from one table to another where version_id in the export table = id in the version060622 table.

i am using the query below but nothing is happening

INSERT INTO version060622 (export_price , dotshop_price , territory_id ) SELECT export_price , dotshop_price , territory_id FROM export WHERE export.version_id = version060622.id

thank you

Gareth

[kakki]

maybe this?

INSERT INTO version060622  

   SELECT export_price , dotshop_price , territory_id 
   FROM export 
   WHERE export.version_id = version060622.id