>>>>is the meaning that if i didn't use recno() in join condition "sql-select"..
>>>>then no any unpredicted result will come out?!
>>>
>>>No, it means if you have two or more tables involved in a SQL-SELECT, then you can't use RECNO() at all. Specifying an alias as it's paramater does not work with a SQL-SELECT.
>>
>>You should never use Recno with SQL. Only PKeys!
>>
>>__Stephen
>
>Only if ya got 'em, you can!
sounds like some VB crap to me, "We dun't need no STINKIN Primary Keys!"