create trigger on northwind datase .. please help

I don't have problem with sending an email, the problem is that the table Orders don't have the total price

the order price is in the Order details table!

thank you for the help btw

Then why not create a trigger on Order details table ?

---

Please specify your SQL Server version while posting questions

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue