Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Jun 2002 @ 18:17:32 GMT


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


Subj:   Re: Aliasses
 
From:   Michael Larkins

Hi Anomy:

Yes you can alias a table name when you reference it in a FROM. So, the following should work fine.

   update mi_mail.aims_out
    FROM mi_vm.vuitsluitingen AS VM
   set mailcode = substr(mailcode,1,5) || 'B'
   where mi_mail.aims_out.client_nr = mi_vm.vuitsluitingen.client_nr
   and (VM.overleden             +
        VM.niet_mailen           +
            VM.niet_ingezetene   +
            VM.taal_niet_ned     +
            VM.Postcode_ongeldig +
            VM.Decentraal        +
            VM.Bagger            +
            VM.Geblokkeerd       +
            VM.Curatele          +
            VM.Beschikkingsmacht +
            VM.Vermogensbeheer   +
            VM.Postretour <> 0  )
   ;

Prior to V2R4, you could actually alias the subject table and the table(s) in the FROM. Now, you can only alias either the subject table or the table(s) in the FROM, but not both.


Regards,

Mike



     
  <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