On Fri, 3 Aug 2001, patrick keshishian wrote:
> Thanks for your reply and suggestions. I was hoping for a
> solution that would not require me to break apart any of the
> tables or employ new ones.
>
> But apparently i have no choice.
>
> One would think that there would a such a construct defined in
> SQL for specifying a field in a table with restriction placed on
> its values based on values in a 'foreign table field'.
Technically, you would be able to handle this through a subquery
in a check constraint, however we don't support this currently
(it's a non-trivial problem to solve for a potentially complicated
query).