Again without the typo -

Query 1 :

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.

In all three, I would expect the same result, but two records returned (set exact is off, so ABCD should match ABC, which it does if I test on the command line).