Transfer Data from one table to another table

[Mvannan]

I have two tables name "test" and "dev"

i am having old data in dev table.

i am having new data in test table.

now i need to update the rows in dev table where primary key is same and insert the row in dev table where the primary key is not same.

thanks in advance

[Rabbit]

Use an update query and join the tables on the key to do the first part. Use an insert query with a left join for the second part.