General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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