Select items by comparing lists of dates

Hi

I have a question and would appreciate some help.
I have an ERGO table in which I have a virtual column DATES1 as a list of different dates.
In another CHECKS table I also have a virtual column DATES2 as a list of dates.
What I want is to select only the raws from the ERGO table where no date from the virtual column DATES1 will be in the list of dates in the virtual column DATES2 from the CHECKS table
What expression can I use to make this choice?

Thanks

0 6 245
6 REPLIES 6
Top Labels in this Space