title: Why can't I use an alias in a DELETE statement?
body: <p>In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don't know), this command works:</p>
  
  <pre><code>DELETE FROM foods WHERE (name IN ('chickens', 'rabbits'))
  </code></pre>
  
  <p>but this command produces an error of: <code>Error near identifier f. Expecting OUTPUT.</code></p>
  
  <pre><code>DELETE FROM foods f WHERE (f.name IN ('chickens', 'rabbits'))
  </code></pre>