Re: SQL joining 4 files together -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.