Just thought I'd point this one out - btw is there an official way of logging this with MS?

It seems that if you run a SELECT - SQL query on a FoxPro4Dos DBF and use an OUTER JOIN it fails to optimize the query.

Doesn't matter if you're JOINing to a VFP table or another Fox4Dos table, still the same result.

Kev