SQL Server: How to Delete or Update Rows with JOIN Clause

A common question asked in every Database Developer interview is that “How to Delete or Update Rows using JOIN Clause to filter effected rows” Not all update and delete quires are as simple as we think. Sometime, we need to update or delete records on the basis of complex WHERE clause. And sometime we can only do this complex FILTERING through joining multiple tables.