Why can’t I use an alias in a DELETE statement?

June 1, 2022 by IT Nursery

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don’t know), this command works:

DELETE FROM foods WHERE (name IN ('chickens', 'rabbits'))

but this command produces an error of: Error near identifier f. Expecting OUTPUT.

DELETE FROM foods f WHERE (f.name IN ('chickens', 'rabbits'))

2 Answers
2