select * from db1 a, db2 b where (a.fld2a=b.fld2b) AND (trim(a.fld1a)=trim(b.fld1b))Query 2 :
select * from db1 a, db2 b where (a.fld2a=b.fld2b) AND (trim(a.fld1a)=trim(b.fld1b)) AND (a.fld2a=b.fld2b)Query 3 :
select * from db1 a, db2 b where (trim(a.fld1a)=trim(b.fld1b)) AND (a.fld2a=b.fld2b)In the first case, I could 1 record returned. In the second 2 I get nothing returned.