SQL joining 4 files together

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Kinda new on this joining but here goes.

I have the following SQL join, of which I probably have compounded errors.
 First error:
Column qualifier or table TPTYPE undefined.  This posititions my cursor on
tptype.tpt400

SELECT login.logid, login.logpas, login.logfnm, login.logcnm,
       login.logacc, login.logact, login.loglev, login.logsts,
       login.logphone, login.logemail, login.logflg1, login.logflg2,
       login.logedte, login.logeusr, login.logmdte, login.logmusr,
       login.logpsod, login.logpwcd, login.logpwei, login.logpwex,
       tpnbr.tpnbr, tpnbr.tpttype, tpnbr.rolecode,
      tptype.tpt400, tptype.tptlib, tptype.tptfile, tptype.tptfield,
      tptype.tptpname, tptype.tpphone, tptype.tpfax, tptype.tpemail,
       tpfacl.tpfacl, tpfacl.tpdrawflr
FROM login left outer join tpnbr
          ON login.logid = tpnbr.logid
     tpnbr left outer join tptype
          on tpnbr.tpttype = tptype.tpttype
     tpnbr left outer join tpfacl
          on tpnbr.logid = tpfacl.logid,
         and tpnbr.tpnbr = tpfacl.tpnbr,
         and tpnbr.tpttype = tpfacl.tpttype


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin