Groups > comp.databases.ms-sqlserver > #1826

multiple JOIN for same table and column lookup

X-Received	by 10.52.232.227 with SMTP id tr3mr1623312vdc.0.1414490522470; Tue, 28 Oct 2014 03:02:02 -0700 (PDT)
X-Received	by 10.140.40.20 with SMTP id w20mr44074qgw.2.1414490522441; Tue, 28 Oct 2014 03:02:02 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!u7no674894qaz.1!news-out.google.com!u5ni13qab.1!nntp.google.com!u7no674889qaz.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 28 Oct 2014 03:02:02 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=96.242.58.190; posting-account=WG_AKQoAAABOEUiyIf1Ow04_BDE0XUgq
NNTP-Posting-Host	96.242.58.190
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<415a780c-2e4c-4f20-9571-c8de38856cdf@googlegroups.com> (permalink)
Subject	multiple JOIN for same table and column lookup
From	Raul Rego <rrego@pmchnnj.org>
Injection-Date	Tue, 28 Oct 2014 10:02:02 +0000
Content-Type	text/plain; charset=ISO-8859-1
X-Received-Bytes	1709
X-Received-Body-CRC	1514304986
Xref	csiph.com comp.databases.ms-sqlserver:1826

Show key headers only | View raw

I have the following select:
ELECT ToxPat.CaseNumber, ToxPat.StartDate, ToxExpSub.SubDesc 

      , ToxExpSub.SubPoisindexCode, CodeValue.CodeValue as 'Call Type' 
from ToxExpSub 

join Toxpat 
     on ToxPat.CaseNumber = ToxExpSub.CaseNumber 
join CodeValue 
     on codevalue.CodeID = toxpat.calltype 

I just received valuable help on how to retrieve child records NOW I need help on the select codevalue.codevalue AND join CodeValue 
     on codevalue.CodeID = toxpat.calltype 

I have many columns with numeric entries where their vertatim values or in the table codevalue thus:
I need multiple JOIN codevalue on codevalue.CODEID = toxpat.reason, calltype, outcome etc.

how can I do this?

thanks,

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

multiple JOIN for same table and column lookup Raul Rego <rrego@pmchnnj.org> - 2014-10-28 03:02 -0700
  Re: multiple JOIN for same table and column lookup Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-10-28 13:33 +0100

csiph-web