Copying data from one table to another

[Mark Schonewille]

Hi,

Because I don't get anywhere modifying my table2, I have decided to 
create a new table table3 and to copy the data from table2 to table3. I 
have created the table and now I execute

REPLACE INTO table3 (field1,key1,field2,field3)
   SELECT field1,key1,field2,field3 from table2;

As you will probably expect, it doesn't work. I do this all the time in 
MySQL. In Valentina, I get error 0x71000 (ERR_SQL_PARSER_ERROR). What 
are possible reasons for this to happen?

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Installer Maker for LiveCode:
http://qery.us/468

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

LiveCode on Facebook:
https://www.facebook.com/groups/runrev/