Posted by John on 08/14/05 15:31

I am hoping to create an updatable view from two tables joined on two
fields. I have two questions;

1. How can I enforce a one to one relation in sql server 2005 based on two
fields? Do I need to create one explicitly under relations? Do I cerate an
index on both fields? Is there a step by step process I can look at to
create one-one relations?

2. Is a view updateable if there is a where clause on one of the fields in
the join/relation?

Thank again.

Regards

[Back to original message]