I want to compare the second column with the 3rd column to find out if there is any row having the same values in both columns.
Let's say, for example, 1st ,3rd and 4th rows have the same values in both the two columns. I would like to add another column to the table which shows me if the rows are compared with eachother.
Currently I have wrote this loop, but it writes 0 eventhough the columns are the same
if(Table1.Interval1 == Table1.ActivityCode1)
Comparison = (Comparison)';
Could you please help me?