Archives of the TeradataForum

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

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

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>>