WB0TRA

SELECT Member.memberid, Member.locationid, Member.membnbr,;
  Member.custnumb, Member.lname, Member.fname, Member.minit, Member.address1,;
  Member.address2, Member.city, Member.state, Member.zip, Member.emailaddr,;
  Member.emailoptin, Member.hphone, Member.wphone, Member.birthyear,;
  Member.birthmo, Member.sex, Member.workshops, Member.haircolor,;
  Member.hairtextu, Member.haircond, Member.skincond, Member.ethnicheri,;
  Member.profess, Member.salesrank, Member.incomplete, Member.sendcard,;
  Member.cardsent, Member.holdmail, Member.enrolldate, Member.expiredate,;
  Member.expired, Member.firstvisit, Member.dblfirrec, Member.lastvisit,;
  Member.membsince, Member.autorenew, Member.active, Member.grandfathr,;
  Member.pointbal, Member.notes, Member.added, Member.updated,;
  Member.updtreas, Location.locnbr, Location.locname, Location.programid,;
  Program.program, Member.bademail, Member.flag1, Member.flag2,;
  Member.refercount, Member.referstart, Member.freecard, Member.emailextra,;
  Member.terminated, Member.seed, Member.phoneoptin, Member.renewdate,;
  Member.emailupdt, Member.nopoints;
 FROM  clubat!member INNER JOIN clubat!location;
    INNER JOIN clubat!program ;
   ON  Location.programid = Program.programid ;
   ON  Member.locationid = Location.locationid;
 WHERE Member.membnbr LIKE ?lcMbrNr;
   AND UPPER(Member.lname) LIKE UPPER(?lcMbrNm);
   AND UPPER(Member.emailaddr) LIKE UPPER(?lcMbrEm);
   AND Member.hphone LIKE ?lcMbrHfon;
   AND Member.wphone LIKE ?lcMbrWfon;
 ORDER BY Member.lname, Member.fname, Member.minit