i have 2 table tab1 and tab2.
tab1 has id,fname1. here id is primary key.
tab2 has id,fname2. here id is primary key.
i run this
insert into tab1(id,fname)select id,fname2 from tab2
and i am able to copy from tab2 to tab1.
now i have some changes in tab2 and few more rows are added in tab2.
So i have to update tab1 table with new rows and update the old ones.
How to write query for this?
View Complete Post