Sub Query Comparing two lists

[chrisbodman]

Hi Everyone,

I’m a bit stuck. Basically, I retrieve a list of people who have a flag set to true (list A). Then I get a list of active cases from CRM (List B). Then I want to check if the customer from List A exists in List B, and if they dont, set the flag to false. I can retrieve both lists, but I’m not sure how I then compare them?

[chrisbodman]

All sorted thank you. I used the combination of a join, followed by a filter to weed out the records I didnt need!

Thank you!