Well, simply USE MyView ALIAS MyAlias then....



>>How about...
>> SELECT MyView
>> COPY TO MyViewTemp
>>
>>
>>>I have a VIEW and I want to run some SQL and change the record set,
>>>and I want to save the original view, because I will need to return
>>>to it. How can I do this?
>
>thanks Steve...COPY TO MyViewTemp copies it to a DBF. ..any ideas?