>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?
thanks Steven for your help..rob