Hi,

Assuming having the followings
- an in memory cursor called adoMemory which includes a field called ItemNo
- a table called items which also includes a field called ItemNo

I want to create another recordset using the following Select statement:

SELECT ItemNo FROM items WHERE ItemNo NOT IN (SELECT ItemNo FROM adoMemory)

Does anybody know if there is a way to do it?
Please let me know.

Thanks in advance.