I think it'l be possible in VFP9 but not in VFP8 or earlier.

>
>I have two views that I would like to combine into a singe view. I have tried various combinations to try and use the results of the first select in the second select but have not been able to get any subquery going.
>
>Here are my views.
<snip>>
>Could someone advise whether or not I can create a single view?
>