is this how you write the update trigger so the table automatically updates
Code:
create trigger updater
begin
update items,sales
set items.number_on_hand = items.number_on_hand - sales.number_sold
where Item_id = sales.Sales_id;
end
note: there are 2 tables
Login
Register
FAQ
Search
