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