>I need to filter based on the recno() of a certain table. This works fine when selecting from one table, but with a join recno() looks at the wrong table and recno('myTable') just returns the current location of the record pointer. Is this possible? Or how about a select statement that show the recno() for each table in a join:
>
>SELECT recno('table1'),recno('table2') from table 1 join table2 ....
>
>I know this won't work, but is there a way to get what I'm looking for in one SQL statement?
>
>Thanks,
>Marcus.


You can't use RECNO() in SQL SELECT. If your boss needs to see this, it is documented in Help.