General information
Category:
Database DAO/RDO/ODBC/ADO
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only