title: SQL fill field with data from another record in same table
body: <pre><code>contract  rec  #     state  dealer  coverage
  --------  ---  ----  -----  ------  --------
  55661     1    YUFL  FL     GP      GP15  
  55661     2    YUFL  FL     GP    
  55662     1    YUFL  FL     GP      GP16  
  55662     2    YUFL  FL     GP
  </code></pre>
  
  <p>Coverage field is empty for REC '2'. How do I fill the coverage field with the same data from REC'1' with the same contract #? Table name: contract_ex</p>
  
  <p>I.e. </p>
  
  <pre><code>55661 REC'2' coverage s/b GP15
  55662 REC'2' coverage s/b GP16
  </code></pre>