>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
interesting suggestion Larry, but I have a question why a HAVING clause? Without a group by CLAUSE, HAVING should act exactly like WHERE.
Anyway... it didn't work. Probably for the same reason that the WHERE didn't work... and that is WHO KNOWS? Thanks for trying to help me with this one... I think I'll be calling MS today... not that I expect any better answers from them than I have found here. If for some unusual reason, MS does know the answer, I'll post my findings. Thanks again.
Erik Moore
Clientelligence