>I tried: select t1.*,t2.* from t1 left join t2 on t1.f1=t2.f1 and !deleted("t2") - select t1.*,t2.* from t1,t2 where t1.f1=t2.f1 and !deleted("t2") - select t1.*,t2.* from t1 left join t2 on t1.f1=t2.f1 where !deleted("t1") and !deleted("t2") ...
John, I do not know the answer, but you can not use deleted("Alias") in a SQL statement for sure
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges