title: Table is specified twice, both as a target for 'UPDATE' and as a separate source for data
body: <p>I am trying to update multiple rows in a column but when I execute query getting error. Somebody guide me where I am wrong. Thanks in advance</p>
  
  <pre><code>  UPDATE TestTaker
    SET TestTaker.Email = 'Replaced'
    WHERE TestTaker.Id IN (SELECT TestTaker.Id FROM TestTaker
    INNER JOIN Questionnaire ON (TestTaker.id = Questionnaire.TestTaker_id)
    WHERE Questionnaire.Project_id IN(SELECT Project.Id FROM Project WHERE NAME LIKE 'abcd'));
  </code></pre>