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?>
--sb--