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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only