sqlteradata-sql-assistant

Getting column parameter doesn't exist error in Teradata

update t1
from 
table1 t1,
table2 t2
set
t1.active_ind=0,
t1.row_status_cd='L'
where
t2.col1
is NULL

Getting "Column/ parameter table 1.t1 doesnt exists" error in Teradata SQL though those fields are available in t1 . can anybody help me to resolve this please?

Solution

  • As you only have to update table1 you don't need the t1 before the columnnames in tne SET, that is why you get the error.

    but shouldn't there be a relation between table1 and table2, but as always you should test this first before using it, that wquery could have unforseen side effects

    update t1
from 
    table1 t1,
    table2 t2
set
    active_ind=0,
    row_status_cd='L'
where
    t2.col1 is NULL