【Trigger】刪除record，另一table中相對應的紀錄刪除

trigger名稱叫：trigger_delete_tmp1
delete tmp1 table中record時觸發並會執行下面的動作
delete from tmp2 where people_id in (select people_id from deleted)
deleted  --->  表示tmp1被delete的那些記錄
當tmp1 table中record del 時 也會刪除相對應的 tmp2 table中record

完整：
ALTER trigger [dbo].[trigger_delete_tmp1]
on [dbo].[tmp1]
after delete
as
Begin
 SET NOCOUNT ON;

 Begin
  delete from tmp2 where people_id in (select people_id from deleted)
 End
End