Is there any way to use the update in this context.
Like...existing rowid should be updated.
non-existing rowid should be inserted.
update b
Set b.column1=a.column1,b.column2=a.column2,b.column3=a.column3
from table2 as b
right join table1 as a
on (a.rowid = b.rowid)
when I run this it is updating only one record. Whereas it should insert the non-existing record and update the existing record. How do do this ?
Thanks in advance.
Ganesh