Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Oct 2000 @ 12:04:09 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Joins
 
From:   Tom Wrobel

im unable to see the problem with this, and suggestions? thanks tom

     SELECT DISTINCT T1.BENEFICIARYID,
      T2.SOCIALSECURITYNUMBER,
      T1.BENEFICIARYNAME,
      T3.ATTENTIONLINE,
      T4.STREET,
      T4.CITY,
      T4.STATE,
      T4.ZIP,
      COUNT (DISTINCT T5.ELIGIBLE_MONTH)
     FROM T1,
      T2,
      T4,
      T5
     LEFT JOIN T3
      ON (T2.BENEFICIARYID =
      T3.BENEFICIARYID
      AND T3.ATTENTIONTYPE = 'C')
     WHERE ((T5.ELIGIBLE_MONTH
      BETWEEN '200001' AND '20012')
      AND (T5.COVERAGE = 'J'))
      AND T2.BENEFICIARYID =
      T1.BENEFICIARYID
      AND ((T2.BENEFICIARYID =
      T4.BENEFICIARYID)
      AND (T4.ADDRESSTYPECODE = 'C'))
     AND T5.BENEFICIARYID =
     T2.BENEFICIARYID
     GROUP BY T1.BENEFICIARYID,
     T2.SOCIALSECURITYNUMBER,
     T1.BENEFICIARYNAME,
     T3.ATTENTIONLINE,
     T4.STREET,
     T4.CITY,
     T4.STATE,
     T4.ZIP ;
      *** FAILURE 3782 IMPROPER COLUMN REFERENCE IN THE SEARCH CONDITION OF A
     JOINED
     TABLE.
      STATEMENT# 1, INFO = 0
      *** TIME WAS 0.180 SECOND.
      *** YOU ARE NOW LOGGED OFF FROM RDBC.

     END OF  72
     FUNCTION?


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016