Re: SQL joining 4 files together

--
Rob,

I would make file tpnbr the primary file in the join, as all files are
joined to that file.

Regards,
Carel Teijgeler.

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