I keep coming across this `DELETE FROM FROM` syntax in SQL Server, and having to remind myself what it does.

```
DELETE FROM tbl
FROM #tbl
  INNER JOIN tbl ON fk = pk AND DATEDIFF(day, #tbl.date, tbl.Date) = 0

```

EDIT: To make most of the comments and suggested answers make sense, the original question had this query:

```
DELETE FROM tbl
FROM tbl2

```