Sorry Yuri, but:

The two statements you mentioned are not equivalent (what is set("exact"), by the way?).

set("exact") have not influence on SELECT SQL command.


This should give the same result as "join":

select * from iciwhs ;
where allt(citemno) in;
(select allt(citemno) from sotemp1) and ;
allt(cwarehouse) IN;
(select allt(cwarehouse) from sotemp1)


only if allt(citemno) and allt(cwarehouse) are unique.