IIRC, there was a problem reported with some slow OUTER JOIN queries in VFP8beta.
>Well, this app was developed in v6.0 and ran fine then, I'm now testing the same project using VFP8 beta to see how it copes.
>
>Kev
>
>>Kevin,
>>
>>I'm still not sure if you consider it a problem in VFP8beta or with query itself. Did you try to run it under VFP6 or whatever VFP version you're using?
>>
>>>I haven't got version 7, we are bypassing it.
>>>
>>>I don't think it is the UNION now, I'm having a similar experience with another select (contains joins).
>>>
>>>It seems to be when I run selects from Fox for dos tables and JOIN them with VFP tables.
>>>
>>>Kev
>>>
--sb--