Look at the attachment.
You'll see that there are multiple records for the field 'new_trackingno' . In most of these sets of multiple records, the field 'new_accountname' is populated only one time. I need to create a SQL script that will populate the records where the blank 'new_accountname' field is NULL with the same data that appears in the 'new_accountname' field that is populated - where 'new_trackingno' is the same. For example, records two, three, and four in the attachment are for new_trackingno 5808, but only the third record's new_accountname field is populated. The script would populate 'new_accountname in records two and four with the data in 'new_accountname' in the third record - where 'new_trackingno' is 5808.
Records five through 8 are the second set - where new_trackingno is 5815, but only record six has data in new_accountname. The script would populate records five, seven, and eight with the new_accountname data in record six...and so on.