title: Help with Update SQL
body: <p>I have two tables (Master, Responses) </p>
  
  <p>I need use the Master_Id field from the Responses table, to look it up in Master table (id) for matching record and update a date field in the Master table with a date field in the Responses table</p>
  
  <p>Master Table's Id field links to Reponses table's Master_id field</p>
  
  <p>Can this be done in SQL ????</p>
  
  <pre><code>UPDATE Master m SET m.date = (
       SELECT r.date FROM Reponses r WHERE r.master_id = m.id)  
  WHERE m.id IN (SELECT master_id FROM Responses) 
  </code></pre>
  
  <p>I get a - General SQL Error - Multiple rows in singleton select. </p>
  
  <p>Do i need to add a join or change something?</p>