There's only one fields in the second table, t2, which I want to use. So the view created is just a copy of t1 with the extra field added. Maybe it's adding both values, though, I suppose.
But the first point you made, that multiple table views are not updateable in SQL is more poignant. I may have to use a dummy table. Thanks. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
