>>
select * from customer where exists (select * from orders)
>>result in C5 error. Expected no error (not talking about SQL being logical or not).
>
>Works find for me. If tables are available, I get browse window. If they are not, I get error "File 'customer.dbf' does not exist".
You do? Then why it's causing a crash here:( Deleted foxuser* already and tested with some other tables too, it doesn't crash if I icnlide a where clause).
Cetin