* 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*************