hi!
i've a problem with using views on db2. i've created a view which selects data from three different tables. when i insert data into each of these tables , no data is inserted into the view automatically. i've create my view as :
CREATE VIEW MYVIEW AS
SELECT t1.column , t2.column , t.column
FROM TABLE1 t1, TABLE2 t2, TABLE3 t3
WHERE t1.somecolumn = t2.somecolumn and t3.somecolumn = t2.somecolumn;...