Hi,
I would like to update a table but am not sure of the most effecient way to do it for this scenario:
What I want to do is set column 4 = II where it's shaded grey.
The logic behind it is to update records where for a set combination of column 2 and column 3 there are zero records with column 4 = II.
I would like to update a table but am not sure of the most effecient way to do it for this scenario:
![selection.png](http://www.mkeates.com/images/selection.png)
What I want to do is set column 4 = II where it's shaded grey.
The logic behind it is to update records where for a set combination of column 2 and column 3 there are zero records with column 4 = II.