Yes, you are right. It is set("ansi") that can affect sql statement.

>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.