What exactly goes wrong?

>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