Hello,

by all means try to avoid using ALLTRIM in your expressions .. FoxPro needs expressions that return fixed length results to be able to use indexes at all

(INDEX ON ALLTRIM(mem_no) will give you an error)

some tips to speed it up:

"INNER Join memcomments On Alltrim(Member.mem_no)=Alltrim (memcomments.mem_no);"

change to just
member.mem_no = memcomments.mem_no ..
or
member.mem_no == memcomments.mem_no

you have to test if this gives you the desired results since some SET settings change the way string comparisons behave .. (see SET EXACT, SET ANSI in help)

"Where Alltrim(memcommets.mem_no) = Alltrim('002191');"

alltrim('002191') ??? .. this makes no sense since there are no spaces to trim .. just use '002191'

so with plain indexes like
INDEX ON mem_no TAG someTag
on both of the tables the query should be at least partially optimizable

Regards
Christian