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