title: SQL Result of SELECT more than one row
body: <p>I have code similar to what is shown below and I keep getting the error - Result of SELECT more than one row</p>
  
  <pre><code>UPDATE myDatabaseOne.myTableOne t1
  SET firstFieldToCopy = (SELECT DISTINCT alternateField 
                          FROM myDatabaseTwo.myTableTwo t2
                          WHERE t1.firstFieldToCopy = t2.alternateField 
                            AND t2.Field &lt;&gt; t2.Field2); 
  </code></pre>
  
  <p>How do I get it to loop for each value in t1?</p>