I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms.
Here is my question:
I have TableA that has the following columns: ID(PK), location, departA, departB.
I would like
a constraint across departA and departB so that both of them can not have NULL values. Both are able to have values.
If one has a NULL value, the other must not be NULL.
The values can be the same for both columns in the row
departA must be unique for its column
departB must be unique for its column
I hope that makes sense, but if not I can clarify.
Thank you for the help!!