Is this possible?

[DOCH]

i want to have a sql statement which moves a record from one table to another, is this possible?
thankyou.

[chazzy]

INSERT INTO the_new_table(column_list) SELECT column_list FROM your_other_table;

[DOCH]

thank's for replying, this si the line i have put in

strSQL = "INSERT INTO savedmail (mailID, recID, content) SELECT (mailID, recID, content) FROM internalmail WHERE mailID =" & mailID & ""


and i am getting the error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression '(mailID, recID, content)'.

/year4/MMT4-155/move2.asp, line 23

line 23 is execute the sql,

any one know where its going wrong,


thankyou.

[chazzy]

that's not a well formed SELECT statement. there shouldn't be paranthesis around the column list.