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:

       

      Table1:
      ID, ValueA
      1, 200
      3, 300
      4, 400
      
      Table2:
      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.