SQL: Moving a row from one table to another.

[Daniel Falkenberg]

List,

I would like to be able to move a row from one table to another table within
the same database.

Off the top of my head I suppose the SQL command would look similar to the
following...

my $sql = 'MOVE * FROM table1 WHERE unique_id = '1111'  TO table2'. FINISH

Then I would like to be able to do the following as well...

my $sql = 'INSERT INTO table2 (crud, crud, crid) VALUES ('crud', 'crud',
'crud')' FINISH

The second is possbile :)

Is the first possible?

Thanks in advance..

Regards,

Daniel Falkenberg