samedi 9 mai 2020

CHECK statement only IF the condition is met

I have to create a table where I need to check a condition only if another condition is met.

To precise I have a table "repair" with columns "solved" and "price", if the column "solved" has value 0 i need to check that the column "price" is equal to 0 too.

How can I do this in the create table statement?

Aucun commentaire:

Enregistrer un commentaire