469,929 Members | 1,443 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,929 developers. It's quick & easy.

db2 view problem

1
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;

i can't find where i'm wrong. Can you help me?
Jan 4 '07 #1
0 1386

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Ryan | last post: by
3 posts views Thread by bughunter | last post: by
12 posts views Thread by Raed Sawalha | last post: by
1 post views Thread by Nogusta123 | last post: by
2 posts views Thread by existential.philosophy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.