From: rrego@pmchnnj.org   
      
   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,   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)