Hi Bob,
If a table referenced in SELECT is opened already, SELECT opens another copy with the equivalent of USE ... AGAIN and uses it. That copy'll be closed when select is complete. Otherwise SELECT will open table as usual and leave it open.
>Hello Sergey
>
>While I do agree with you that Select SQL doesn't change the record position of the Source Table at all, I am not sure about ' It never uses already open tables'.
>
>I could open a table, run a Select SQL against it and I see only the Source table and the query result in the data session, the same 2 tables can be seen if the source table was not opened.
>
>I am interested in hearing your explanation.
--sb--