1 Reply Latest reply: Jan 28, 2017 6:43 PM by Marco Wedel RSS

    Using where not exist

    Abhay Sudhakaran

      Hi There,

       

      How to find the differences in a column (similar) between 2 tables.

       

      Example: There are 2 tables (Fact1 and Fact2), each containing a common field called "ID". I want to find out which values do not exist in Fact2.

       

      Desired Result - "B" and "C"

      I Where not exists.png

       

      Thanks,