Delete all rows in a table based on another table

Question

I can't seem to ever remember this query!

I want to delete all rows in table1 whose ID's are the same as in Table2.

So:

DELETE table1 t1  WHERE t1.ID = t2.ID 

I know I can do a WHERE ID IN (SELECT ID FROM table2) but I want to do this query using a JOIN if possible.

Answer 1

DELETE t1  FROM Table1 t1 JOIN Table2 t2 ON t1.ID = t2.ID; 

I always use the alias in the delete statement as it prevents the accidental

DELETE Table1  

caused when failing to highlight the whole query before running it.