Delete From Multiple Tables

Hi, I'm learning SQL and I can't find on how to delete data from multiple tables, is there any way in doing this? I'm creating a stored procedure where I input the ID I wanted to delete in 2 tables, 1st table has unique ID and a column which references to the 2nd table.

Example:

table1

id | reference_code

1  | 123456

table2

reference_code

123456

I want to delete both entries on two tables just by calling the id from table 1