Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER after_table_update
- After_hsi.keyrecorddata202_UPDATE
- FOR EACH ROW
- BEGIN
- UPDATE hsi.keyrecorddata202
- SET kg563 = hsi.keyrecorddata202.kg275 * ['Price_List$'].Unitprice
- FROM hsi.keyrecorddata202
- INNER JOIN ['Price_List$'] ON hsi.keyrecorddata202.kg487 = ['Price_List$'].NO#
- WHERE kg568 = 'FOOD'
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement