>The best solution, if you had access to the Oracle database would be to install a view there and then pull that view into a remote view in VFP. You might try this: Create a remote view in VFP for each Oracle table and then do the join in VFP. That's about the only other possiblity I can think of.
>
>Good Luck!
>
>Gregg

Will see if the Oracle administrator has any views I can use. Otherwise, I will break it down into many remote views and create another view from them.

Thanks to both you and Mark for your help.