This is my question and i have the following scripts ineed to create a trigger for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels.
CREATE TABLE ShippingLabels
I need this The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows
CREATE TRIGGER addto_shippinglabels
INSERT INTO ShippingLabels
SELECT up.vendorid, up.address1, up.address2
FROM invoices up