Yes there is, but I figured out how to use a trigger to enforce the constraint.  In fact there was a perfect example of what I needed in the BOL...

quote:

---

Is there an advantage in putting the inequality in the join statement rather than in a WHERE clause? Does the query...