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? ...
Each table has a column with a matching value with each other..
Each table has a column with a matching value with each other..
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.
- Christann
Advocate IV
Is there a reason that you cannot create a relationship based on those columns?
yes, one is only Numeric and another one allows alph numeric values as well.
