I have a SQL query and I know this is just simple one but for some reasons I cannot get it to work.
What I want to accomplish is if there are 2 more columns with the same values from Column1 to Column 3 but not the same value with Column4, then add new column and insert Column4 2nd output value into NewColumn.
Is this possible or any suggestions is appreciated.
Thank you again for all your help. I really appreciate it.