title: SQL error or missing database (near ".": syntax error) error in java when trying to update data from sqlite databse
body: <p>i keep getting this error in java. I did look at similar questions but they didnt help. Can someone solve it? thanks</p>
  
  <pre><code>UPDATE SearchedWords 
  SET SearchedWords.NrOfSearches=SearchedWords.NrOfSearches+1 
  FROM SearchedWords
  INNER JOIN Dictionary ON SearchedWords.WordID=Dictionary.ID 
  WHERE Dictionary.Word=? AND SearchedWords.UserID=?;
  </code></pre>