Update view problem

Thank you for any help.

create view v1 as select a.* from t1_at_db1 a union b.* from t1_at_db2 b; update v1 set x='new' where x='old';

But this update is illegal, I think it is because the x(old) cannot be located either from t1_at_db1 or t1_at_db2.

Then, how to make it become LEGAL? I used to replicate the same value to two identical tables (tablename, columnname) to two different databases (sites).

--
Johnson Chow Received on Thu Nov 18 1999 - 09:32:39 CST