Forum Discussion
Solved
Filter table by table
Hi,
I am looking for soultion for this case.
Assume I have two tables like this :
| Table1 | Table2 | ||||
| Id | Name | Id | Value | ||
| 1 | Adam | 5 | 40 | ||
| 2 | John | 6 | 45 | ||
| 3 | Peter | 3 | 55 | ||
| 4 | Megan | 4 | 42 |
What I would like to get is table table one to be filtered out with ID values from table2 . ( In sql I would use "ID is not in" )
So my result will be :
| Id | Name |
| 1 | Adam |
| 2 | John |
So values with IDs 3 and 4 are filtered out becasue they exist in column Id of table2
