I am fairly new to SQL and I have run into a problem. I am trying to create a table that has among other things two columns, one named Call_Type and the other Score. Now when inserting in values, if Call_Type is "Single" then Score can be NULL, otherwise it cannot be NULL.
The problem is that I'm not sure how to code this. What I want is there to be an error if a user enters something like:
INSERT INTO myTable (Call_Type) VALUES
('Multiple');
Since in this case score cannot be NULL. Anyone know how to code this?