title: SQL UPDATE (copy from row to row)
body: <p>I want to try to copy a value from one record in a Table to another record in the same table an same column.</p>
  <pre><code>    UPDATE
      [PDF]
  SET
      [PDF].[description] = [MISC].[description]
  FROM (
      SELECT
            [PDF].[TPYE]
           ,[ID]
           ,[PDF].[description]
      FROM [DB1] AS [PDF]
      
      INNER JOIN (
          SELECT
               [TYPE]
               [description]
               [ID]
          FROM [DB1]
          WHERE [TYPE] = 'MISC'
              ) AS [MISC] ON [PDF].[ID] = [MISC].[ID]
  WHERE
      [PDF].[TPYE] = 'PDF'
  </code></pre>
  <p>For more clarification ive added a screenshot.<a href="https://i.stack.imgur.com/Ixolu.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>The Table contains a few thousands rows, and i want to copy the description from one row to another - dependent on NUMBER and TYPE.</p>