title: How delete table inner join with other table in Sqlite?
body: <p>My query:</p>
  
  <pre><code>DELETE a FROM TR_ContactResultRecord  a
  INNER JOIN TR_Case  b on (a.FireStationCode=b.FireStationCode and a.CaseNo=b.CaseCode )
  WHERE b.Update_DateTime &lt;=20140628134416
  </code></pre>
  
  <p>It show error: <code>[Err] 1 - near "a": syntax error</code></p>
  
  <p>How delete table inner join with other table in Sqlite?</p>