I have a list and I need to filter it down more. I need to use data from a table to filter it more.
My list is Enrollments. I am able to get to Enroll.Emp.perID. I need to filter the table TermedEmp which has field perID also. Basically in SQL it would work like this.
From Enroll.Emp e
Where e.perID not in (
Select perID from TermedEmp