User1052662409 posted
Hello Everyone,
I need to transfer some of columns data from from one table to another.
I can do it easily using the below query
INSERT
INTO table2 (column1, column2, column3, ...)
SELECT column1, column2,
column3, ...
FROM table1
Here I have a condition, that id the mentioned columns data already exists in table2 then it should update the data otherwise it should insert the remaining data which is not exists in table2 and I don't want to use any external
parameter for that.
Please suggest.
Thanks