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

multiple JOIN for same table and column lookup

Newsgroups	comp.databases.ms-sqlserver
Date	2014-10-28 03:02 -0700
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>

Show all headers | 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