title: copy one column from one table to another
body: <p>I am confused about how to copy a column from one table to another table using where. I wrote SQL query but it says transaction lock time exceeded or query returns more than one row.<br>
  using mysql<br>
  Basically,<br>
  I have:  </p>
  
  <pre><code>Table 1:  Results
  BuildID  platform_to_insert
  
  Table 2:  build
  BuildID correct_platform
  
  update results set results.platform_to_insert 
       = (select correct_platform from  
         build where results.BuildID = build.BuildID)
  </code></pre>