>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