In SQL Server, to delete records from a table following a criterion that is related to another table in the database you can establish a join between the two tables in the same SQL Delete statement.

In SQL Server, to delete records from a table following a criterion that is related to another table in the database you can establish a join between the two tables in the same SQL Delete statement.

If we want to make a record delete using a join we must specify in the first line of the statement the table in which we want to apply the deletion of records, and in the next line the join of the tables we need, and the criterion indicated with a where..