 <p>This <code>DELETE</code> all the records from the table <code>abc</code> with <code>JOIN</code> to another table. It deletes all the records in the table <code>abc</code> that has a <code>RECORD_TYPE</code> value equal to the <code>RECORD_TYPE</code> in the other table AND in the same time the value <code>IN</code> are equals in the two table.</p> <p>It is a normal <a href="http://msdn.microsoft.com/en-us/library/ms189835.aspx" rel="nofollow"><strong><code>DELETE</code></strong></a> clause, Where the <code>FROM</code> can contain extra joined table as specified by the documentation:</p> <blockquote> <p>FROM clause:</p> <p>This extension, specifying a join, can be used instead of a subquery in the WHERE clause to identify rows to be removed.</p> </blockquote>