This content has been marked as final. Show 6 replies
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.