Archives of the TeradataForum
Message Posted: Fri, 16 Apr 1999 @ 12:23:10 GMT
| Subj: || || Re: Table alias in updates |
| From: || || John Hall |
I've tried the same thing in the past (V1 and early V2) without much success. I looked around this morning and maybe using ANSI syntax
will work for you (sorry, I can't test it myself).
update database1.t_table AS t1
from database1.s_table AS t2
set primary_rc = t2.primary_rc
where t1.primary_rc = '0000'
and t1.household_num = t2.household_num
and t2.period_end_date = 981231;