Forum Discussion

Arial12's avatar
Arial12
Frequent Visitor
8 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
Arial12's avatar
Arial12
Frequent Visitor
8 years ago

Tables don't have a relationship.

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
8 years ago

Then how do you know which values to compare?

  • Arial12's avatar
    Arial12
    Frequent Visitor
    8 years ago

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

    • Arial12's avatar
      Arial12
      Frequent Visitor
      8 years ago

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

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

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