SQL TRIGGER: Add a trigger to your check table (or equivalent) so that whenever a new sale
Fantastic news! We've Found the answer you've been seeking!
Question:
SQL TRIGGER: Add a trigger to your check table (or equivalent) so that whenever a new sale of a menu item occurs (i.e. a new INSERT to Check Detail), automatically deduct the quantity from the quantity on hand of that item's inventory.
Please show an example of a trigger statement that goes with the question above.
You may use your own tables/values but please explain what the tables mean.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: