Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: data retrieve on parent and many child instances

Show all headers | View raw

Raul Rego (rrego@pmchnnj.org) writes:
> NOW can I issue multiple JOIN like this join CodeValue 
>      on codevalue.CodeID = toxpat.calltype .  reason being is Codevalue
>      table has the definitions for many fields numeric entries 
> For example, I will also like to use:
> Join Codevalue on Codevalue.CodeID = toxpat.ReasonCall
> 
> is it possible to issue multiple Join codevalue on codevalue.codeId = >
> toxpat.Column1, column2, etc 


Once you start to learn to use aliass (which you should because it enhances
reaability), it all comes naturally:

SELECT tp.CaseNumber, tp.StartDate, tes.SubDesc, 
      tes.SubPoisindexCode, cv_ct.CodeValue as "Call Type",
      cv_rc.CodeValue AS "Reason to Call"
from ToxExpSub  tes
join Toxpat tp  on tp.CaseNumber = tes.CaseNumber 
join CodeValue  on cv_ct.CodeID = tp.calltype 
join CodeValue  on cv_rc.CodeID = tp.ReasonToCall
where exists ( 
     select 1 from ToxExpSub x 
     where x.SubPoisindexCode = 6931087 
       and x.CaseNumber = tp.CaseNumber 
) 


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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

Thread

data retrieve on parent and many child instances Raul Rego <rrego@pmchnnj.org> - 2014-10-27 22:47 -0700
  Re: data retrieve on parent and many child instances Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2014-10-28 07:08 +0100
  Re: data retrieve on parent and many child instances Raul Rego <rrego@pmchnnj.org> - 2014-10-28 02:54 -0700
    Re: data retrieve on parent and many child instances Erland Sommarskog <esquel@sommarskog.se> - 2014-10-28 11:37 +0000

csiph-web