Hi,

i need other info, but...

***********
remove order because it in not optimizable ( add it after ) and try this:

* need a index on Pocontact.memoid
SELECT *;
 FROM  FORCE property!propnum LEFT OUTER JOIN property!pocontact ;
   ON  Pocontact.memoid = Propnum.contactid;
 WHERE LEFT(Propnum.groupid,2) == "PN"
* a index on LEFT(Propnum.groupid,2) is usefull also

*************
post: RECCOUNT(property!propnum) and RECCOUNT(property!pocontact)
*************
This is a remote view on a VFP ODBC ?
I donnot use this, for now, and i haven't big experience for get max optimization.

Fabio