For years, SQL Server has supported a (second) FROM clause in UPDATE and DELETE statements. Its behavior isn't always deterministic, a fact Microsoft points out in the documentation. Today, someone was surprised by the basic semantics of DELETE .. FROM.
Read More...