Web Development



SQL statement/vb6 code

By penzzap ·
help! i am trying to copy a record from table1 to table2 at the same time i want to show the changes of table1 to table 2. How?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Use a select in your insert statement

by mikealparfrey In reply to SQL statement/vb6 code

INSERT table2 (col1, col2, col3)
SELECT col1, col2, col3
FROM table1
WHERE id = <your id here>

I'm not sure how you want to display your changes if you want to do a direct copy? Could you be more specific as to why you need to show the changes? That might help.

Related Discussions

Related Forums