Unique constraints across tables?

From: <swilson669_at_my-dejanews.com>
Date: Wed, 11 Nov 1998 19:26:05 GMT
Message-ID: <72cocd$5sc$1@nnrp1.dejanews.com>

I am trying to find the best way to make two fields in two different tables unique together. I don't think that this can be done in a constraint, and am thinking that it should be done in a trigger. I thought that I would just confirm my thoughts before doing this.

The structure looks like this:

TABLE1
ID PK
TERMINATION_DATE DATE NULL TABLE2
ID FK
TELNO VARCHAR2 NULL Telno and Termination_date are to be unique together not separately.

I would appreciate any help, with this. Thanks in advance. SWilson

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 13:26:05 CST