Strange contraint help please...
From: harry <a_at_abc.com>
Date: Thu, 29 Nov 2001 10:22:09 GMT
Message-ID: <vo2c0uooh12rrv7bsfssqk1coshe0om60r_at_4ax.com>
Date: Thu, 29 Nov 2001 10:22:09 GMT
Message-ID: <vo2c0uooh12rrv7bsfssqk1coshe0om60r_at_4ax.com>
Using Oracle 8i on win NT 4 server(sp6a)
How can I get around this problem? - I have 3 tables with one column each -
A
=
ID number(8)
B
=
ID number(8)
C
=
ID number(8)
containin data
A
=
1
2
3
C
=
4
5
6
B
=
1
2
3
4
5
6
how can I add a referential integrity constraints to table B that ensures the values exist in tables A OR C ?