>>Strange. Derived tables should not work with enginebehavior < 9
>
>No, Derived table usage is not controlled by SET ENGINEBEHAVIOR

Sergey,

Thank a lot for correcting my statement. Appreciate it.

Interesting. It was an enhancement in the query engine in VFP9. So, are you saying that it works with SET ENGINEBEHAVIOR 8 as well?

But it would not work in VFP8, correct ?

In other words, even with SET ENGINEBEHAVIOR 7 or 8 we can still use new features in VFP9?

Thanks again.