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

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,