create view v_upd_table as select a.rowid z_rowid, b.new_value from table_target a, table_source b where a.pk_column = b.pk_column;