Could someone please give me an example of a simple delete trigger. Basically I have two tables in SQL Server 7 that have a relationship and I need to have a trigger that will delete the matching records from both tables. So if I delete a record from my_Table1, I need the matching record from my_Table2 deleted. I think it is something like the following but I am not sure.
CREATE TRIGGER Delete_my_Data ON my_Table1
DELETE from my_table2 where my_Table1.groupid = my_Table2.groupid