Delete command with a join

It’s possible in SQL Server to run a delete command against a table, and join it with another. To do this though, you need to use an alias with the table.