title: insert date from neighbor entry
body: <p>Table has columns for <code>issue_date</code>, <code>part_num</code> and <code>date_received</code>.</p>
  
  <p>If an  <code>issue_date</code> is <code>null</code>, I want to select <code>issue_date</code> of <code>part_num + 1</code> (the next part number), and insert it in the <code>issue_date</code> column of the part with no issue date.</p>
  
  <p><code>part_num</code> is sequential.</p>
  
  <p>What sql statement would select then insert the appropriate issue date?</p>
  
  <p>Thank you in advance for any help.</p>
  
  <p>Figured it out with a little self join statement.. thank you delete if you wish!!</p>