>>>>How can I create a union in a remonte view(connected to Oracle)?
>>>The quick answer is the same way as in your local views. (Without knowing more details)
>>
>>How do you create a SQL pane that is editable?
>
>I can not find a way to enter Unions using the remote view (connected to Oracle). In the VFP help I see talk about SQL pane. I can't find where to use that either.
Austin,
To do a join with a remote data source you have two choices. 1) write a stored proc in teh database and call it from VFP with SQLPassthrough. 2) create two remote views to get the data from the backend and then use a SELECT with a union on those two views.