>Again without the typo -
>
>Query 1 :
>
>select * from db1 a, db2 b where (a.fld2a=b.fld2b) AND (trim(a.fld1a)=trim(b.fld1b))
>
>
If you're really using local aliases of a and b, try it again without them or with local aliases that don't use the single letters a-j or m.
Tamar