Hi,

Maybe I am missing something obviouse, here is the problem:

I want query from a table by a set of known recno(), something like this if it will work:

SELECT FROM tableA WHERE RECNO() IN (SELECT nRecno FROM tableB)

tableB only have one column nRecno which to store needed recno().

This is a data cleaning process, I can not afford to alter tableA because the size.

Thanks in advance.

Jun