Variable constraint messages: Example 1
In the Travel Agency, the business rule: "Guides must have a bank account" is implemented by a restrictive, single-record constraint:
Because the first_name and last_name columns are specified in the SELECT clause, you now can specify the message:
The error message displayed will be:
You can also refer to alias names and labels.