Subject Testing a ref constraint violation
Author Martin Ågren
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 who’s constraint fields are non existent in table A?



TIA,



/M





[Non-text portions of this message have been removed]