how to delete a row from two table by passing single variable

begin transaction;
 
   declare @deletedIds table ( id int );
 
   delete t1
   output deleted.id into @deletedIds;
   from table1 t1
    join table2 t2
      on t2.id = t1.id
    join table3 t3
      on t3.id = t2.id;
 
   delete t2
   from table2 t2
    join @deletedIds d
      on d.id = t2.id;
 
   delete t3
   from table3 t3 ...
 
commit transaction;

DELETE FROM table_name
WHERE some_column=some_value

DELETE  FROM messages INNER JOIN usersmessages
WHERE messages.messageid= usersmessages.messageid and messages.messageid = 1

DELETE MESSAGES  FROM MESSAGES INNER JOIN USERSMESSAGES
ON MESSAGES.MESSAGEID= USERSMESSAGES.MESSAGEID WHERE MESSAGES.MESSAGEID = 1