title: DELETE FROM `table` AS `alias` ... WHERE `alias`.`column` ... why syntax error?
body: <p>I tried this with MySQL:</p>
  
  <pre><code>DELETE FROM `contact_hostcommands_relation` AS `ContactHostCommand` WHERE (`ContactHostCommand`.`chr_id` = 999999) LIMIT 1
  </code></pre>
  
  <p>And I get this:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`ContactHostCommand`.`chr_id` = 999999) LIMIT 1' at line 1
  </code></pre>
  
  <p><em>Note:</em> This query is automatically generated and conditions are based on table aliases.</p>
  
  <p>Why I get this error?</p>
  
  <p>Is there any way to use table aliases in where clause?</p>
  
  <p>Is this MySQL specific?</p>