I'm trying to overwrite values that are found in TYPE1 with values that are found in TYPE2.
I wrote a fiddle to try it out, but for some reason it isn't updating.
Any reason why my values in TYPE1 are not updating?
This works for me
select * from stuff update stuff set TYPE1 = TYPE2 where TYPE1 is null; update stuff set TYPE1 = TYPE2 where TYPE1 ='Blank'; select * from stuff