How about trying...
SELECT Memb.nickname, Memb.lname, Histcode.histdesc, History.histyear,;
Memb.mcampus, History.histtype, Memb.membnum, Memb.address1, ;
Memb.address2, Memb.city, Memb.st, Memb.zipcode, Memb.tel,;
deleted("history") as isdeleted ;
FROM temptest!memb INNER JOIN temptest!history;
INNER JOIN temptest!histcode ;
ON History.histtype = Histcode.histcode ;
ON Memb.membnum = History.hmembnum;
WHERE Memb.mlocalnum = ?m.mlocalnumber;
AND LEFT(History.histtype,3) = "OFL";
HAVING isdeleted= .F. ;
ORDER BY History.histyear DESC, History.histtype