Forum Discussion

Arial12's avatar
Arial12
Frequent Visitor
7 years ago

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?  ...
Need Help
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Then how do you know which values to compare?

Arial12's avatar
Arial12
Frequent Visitor
7 years ago

Each table has a column with a matching value with each other..

  • Arial12's avatar
    Arial12
    Frequent Visitor
    7 years ago

    Each table has a column with a matching value with each other..

    • Christann's avatar
      Christann
      Icon for Advocate IV rankAdvocate IV
      7 years ago

      Is there a reason that you cannot create a relationship based on those columns?

      • Arial12's avatar
        Arial12
        Frequent Visitor
        7 years ago

        yes, one is only Numeric and another one allows alph numeric values as well.