6 Replies Latest reply: Mar 15, 2016 5:56 AM by Georg Gottsmann RSS

    Where-Clause for another table to exclude data sets

    Georg Gottsmann

      Dear all,


      Let's say I have two tables:


      ID, ValueA
      1, 200
      3, 300
      4, 400
      ID, ValueB
      1, 999
      2, 888
      3, 777


      How can I load them, but exclude the records of Table2 where ValueB < ValueA in Table1? The ID is the same key for both tables. I tried JOIN, KEEP, RESIDENT and more, but nothing worked.


      Thank you in advance.