Subject | Testing a ref constraint violation |
---|---|
Author | Martin Ågren |
Post date | 2007-08-07T14:25:12Z |
Hi there,
I want to set up a multi column foreign key from table B (detail) to A
(master), but it fails due to violation of the primary key in A.
How would the most straightforward SQL look, if I want to find the records
in table B whos constraint fields are non existent in table A?
TIA,
/M
[Non-text portions of this message have been removed]
I want to set up a multi column foreign key from table B (detail) to A
(master), but it fails due to violation of the primary key in A.
How would the most straightforward SQL look, if I want to find the records
in table B whos constraint fields are non existent in table A?
TIA,
/M
[Non-text portions of this message have been removed]