I am trying to retreive data from multiple files. Any of then can
have deleted records. A simplified version of my problem is.

The code

Select * from vitens where !deleted('vitems')

and

Select * from vitems, vorders where vitems.clordno = cordno

both work as expected but combining them

Select * from vitems, vorders where vitems.clordno = cordno ;
and !deleted('vitems')

produces no output. Why?