>>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
Been there, done that - but just tried again to reassure myself - it's one of the reason the example used distinct field names, so I could do away with the local aliases.
As I said elsewhere, this ones been with me for over 5 years & early on, I tried everything I could think of to resolve the problem. The guy on the MS support desk told me this was how it should work, but everyone else says it should work how I expect (ie same results in all 3 cases).
Can anyone else try it & see if they get the same results.
Len Speed