>Hi Cetin,
>
>>
select * from customer where exists (select * from orders)
result in C5 error. Expected no error (not talking about SQL being logical or not).
>
>Do you have an index on MLINE() in one of the tables? I found MLINE() to cause crashes in VFP 9 sometimes when used in a grid as a controlsource or as an index tag.
No I don't I never thought to create such an index. Looks like related with 'set deleted off' and having deleted records.
Cetin