If there are no matches, then it does not matter what method is used.
Consider this:
table1.field1
"600 "
"600 "

table2.field1
"602 "
"602 "

SELECT field1 FROM table1 WHERE ALLTRIM(field1) in (sele ALLTRIM(field1) FROM table2) && no records

select table1.field1;
from table1,table2;
WHERE ALLTRIM(table1.field1)=ALLTRIM(table2.field1) && no records

and inner join gives no records too.


>Hi Yuri,
>
>I see what you mean now.
>How would you narrow the result set to 0 records since there really are no matches
>
>Thanks
>carmel