Thank you. At first, I didn't understand this but see that, if rows change strongs_no values from not 'punc2' to 'punc2', they would not get set to null on a new update run without this union code. That is something I would have definitely missed, especially since have never used a window function before.