Thanks Sergey

Any idea when the final release of VFP9 is going to be?

Geoff

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