>>>Thank you all. I got this view thing working, now... how can I append the results of this two table view to another table?
>>>Append from doesn't work with views AFAIK...
>>>
>>>Ulises
>>
>>You could try COPY TO [tablename] and APPEND from there, or COPY TO ARRAY and APPEND FROM ARRAY
>
>Would append from dbf('MyView') work?

Yes, that will work too.