Web Development

Ask something
Question Locked

SQL statement/vb6 code

0 helpful
2 replies

by penzzap

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

thanks.
vc

2 replies

by mikealparfrey

INSERT table2 (col1, col2, col3)
SELECT col1, col2, col3
FROM table1
WHERE id =

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.

This discussion is closed to new replies.