Forum Discussion
Case like statements - Compare two table columns
Hi Experts, I have two table with similar column that i want to compare and calculate a column. something like this, if tabl1.col1 = tabl2.col1 then "yes" else "NO" any suggestion? ...
yes, one is only Numeric and another one allows alph numeric values as well.
Convert the numeric column to text and create a relationship between the two. If you need to run calculations off the column that then can use the VALUE function or create a duplicate column using a numeric data type.