Multiple triggers

[Ken Quad]

Hi all:

Got this syntax from a previous thread to delete "orphan" records in auxiliary tables when the parent record is removed:


DELETE un
FROM unit_notes_main AS un
LEFT JOIN units_main AS u ON u.unit_id = un.unit_id
WHERE u.unit_id IS NULL

(this deletes all notes pertinent to a given "unit", obviously).

Problem is, I need to execute 3 of these statements, 1 for notes, 1 for options, and 1 for curtailments. (Call them n, o, and c if you like). The function is the same, only I can't figure out how to do multiple triggers. If I try to create more than one "after-delete" trigger, I get "Trigger alread exists" (though the syntax of the second trigger is of course diffferent from the first). And I don't know how to concatenate the statements or execute one after the other in the same trigger. I'd appreciate any help. Thanks.

Ken Quad