Hi all,
I have a probably trivial question, but I am not able to find an answer.
I have five foreign keys in a table to five different tables that represent different kinds of same entity.
I want to check that only one foreign key is set to a not null value per row.
How can I code this check?
Thank you very much.
I have a probably trivial question, but I am not able to find an answer.
I have five foreign keys in a table to five different tables that represent different kinds of same entity.
I want to check that only one foreign key is set to a not null value per row.
How can I code this check?
Thank you very much.