DELETE (Transact-SQL) - MSDN - Microsoft

This Transact-SQL extension to DELETE allows specifying data from < table_source> and ... This extension, specifying a join, can be used instead of a subquery in the WHERE clause to ...

msdn.microsoft.com