title: I am getting a #1248 - Every derived table must have its own alias. I am using a WAMP server
body: <p>Could anyone tell me what is wrong with this and why I am getting the error #1248 - Every derived table must have its own alias. ?</p>
  
  <pre><code>UPDATE (SELECT t.crime_definition p1, s.crime_definition p2
    FROM crime_2007 t, crime_2010 s 
    WHERE crime_2007.crime_id_2007 = crime_2010.crime_id)
  SET p1 = p2
  </code></pre>
  
  <p>I have researched for a long time and I can't pin point the problem. I am trying to copy a column from one table to a column in a different table.</p>
  
  <p>thank you in advance!</p>