Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 18:57:43 GMT

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

Subj:   Re: Populating one column with data from either of two table.
From:   Scott Thompson

  I have been thinking of a good efficient way to do this and I could use the help ...  

is this perhaps what you're looking for? :

SELECT (CASE WHEN LA.column_to_check = 'what i want'
             then LA.column_i_want
             WHEN A.column_to_check = 'meets secondary conditions'
             then A.column_i_want
             WHEN LA.column_to_check2 = A.column_to_check2
             then LA.column_i_want2||A.column_i_want2
             ELSE 'stick generic message in col1'
        END) as col1,
        col3, .... coln

     BA.Dly_AccNT A, BA.Dly_Accnt_Risk AR,
     ba.Dly_Ppant PART

WHERE LA.process_dt     = LDR.end_extract
AND   A.ba_accnt_nbr    = LA.ba_accnt_nbr
And   A.process_dt      = LA.process_dt
AND   A.ba_accnt_nbr    = AR.ba_accnt_nbr
And   A.process_dt      = AR.process_dt
AND   PART.ba_accnt_nbr = A.ba_accnt_nbr
And   PART.process_dt   = A.process_dt

obviously, change the column names, comparison conditions, and return values in the case statement to something more specific to your actual tables and columns and suitable to your needs.

  <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: 23 Jun 2019