title: Copy column values from one table to another
body: <p>I'm trying to create a T-SQL query for several hours now. Google and the forum search did not help, so I hope someone can help me with this.</p>
  
  <p>There are two tables, <code>Change</code> and <code>Journal</code>. Each row in <code>Change</code> has 5 related rows in <code>Journal</code>.</p>
  
  <p>What I want to do is to copy the column value (<code>CreatedDateTime</code>) of a specific related row from <code>Journal</code> into the column <code>AuthorizationDate</code> of <code>Change</code>. This should be done for all rows in <code>Change</code>.</p>
  
  <p>This is what I've achieved so far:</p>
  
  <pre><code>UPDATE Change 
  SET Change.ap_ITSM_MDP_AuthorizationDate = 
      ( SELECT Journal.CreatedDateTime 
        FROM Journal 
          JOIN Change 
            ON Journal.Parentlink_RecID = Change.RecID 
        WHERE ITSM_ChangeNotes_Subject = 'Status changed to: Authorized' 
          AND Change.RecID = Journal.ParentLink_RecID
      )
  </code></pre>
  
  <p>Unfortunately, I get the following error message:</p>
  
  <blockquote>
    <p>Msg 512, Level 16, State 1, Line 1
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.
    The statement has been terminated.</p>
  </blockquote>
  
  <p>I thought I DID limit the result to one by the WHERE clause (<code>ChangeNotes_Subject = '...'</code>). What did I do wrong?</p>