From: erik.lennart.jonsson@gmail.com   
      
   On 2014-10-28 11:02, Raul Rego wrote:   
   > 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,   
   >   
      
      
   Do you mean:   
      
        ON codevalue.CODEID IN (toxpat.reason, toxpat.calltype,   
   toxpat.outcome, ...)   
      
   ?   
      
      
   /Lennart   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)