Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Using views

Author  Topic  jraha Starting Member 16 Posts Posted - 2001-02-27 : 11:12:09 I have 2 different applications (application A and application B) on my intranet inserting and selecting from a set of tables. Application A only wants to see the records in the tables inserted by application A while Application B wants to see the records in the tables inserted by both applications A and B. Due to legacy code, I thought that I would create the tables as such: tblOne, tblTwo, tblThree .... and then tblOneMirror, tblTwoMirror, and tblThreeMirror. Then Application B could insert into the Mirror tables and select from a view that looks like this: tblOne UNION tblOneMirror Problem is this: I can't/don't know how to create that view using SQL 7.0. Much appreciate any help.