Hi Caroline,
Remember, you can use a view that's in another datasession.
See the last few paragraphs of http://home.kscable.com/cschreiner/OutFoxed16.html


>Thanks Vlad I suspected as much.
>
>>Hi!
>>
>>No, it is not possible. In addition, USE ... AGAIN command opens file phisically and does not re-use the alias opened in another data session. So when you can some result of SELECT statement in one data session, you cannot re-open it again in another data session, just becuse it is opened exclusively and attempt to open it in anotehr data session fails because phisically it is not available - exclusive use.
>>
>>
>>>Does anybody know if it is possible to create a SELECT statement that uses tables that are open in one private data session but places its result in another private data session. (VF7)
>>>
>>>Any help greatly appreciated.