> So, Select *, recno() from table1 inner join table2 on ... Would not work? Thanks for this warning.

It works, but recno() is applied to table1. Anyway, this is just an observation, not a documented behavior.

It's better to avoid any functions like recno(), deleted(), etc that can be confused by the current alias (which is never
known precisely in a SELECT statement). Worth noticing that these functions cannot be used with an alias
as param in a SELECT.

Vlad