CREATE TABLE updatetable(
    id INTEGER,
    name VARCHAR(100),
    indicator_flag CHAR(1)
)
 
CREATE TABLE othertable(
    id INTEGER,
    name VARCHAR(100),
    indicator_flag CHAR(1)
)
 
INSERT INTO updatetable VALUES(1,'Teradata',null);
INSERT INTO updatetable VALUES(2,'Database',null);
INSERT INTO updatetable VALUES(3,'Oracle',null);
INSERT INTO updatetable VALUES(4,'Vertica',null);
 
INSERT INTO othertable VALUES(1,'Teradata','Y');
INSERT INTO othertable VALUES(2,'Database','N');
INSERT INTO othertable VALUES(5,'DB2','Y');
INSERT INTO othertable VALUES(6,'MYSQL','Y');
 
UPDATE tempAggr
FROM updatetable as tempAggr,
     othertable as tempTableAlias
SET indicator_flag = tempTableAlias.indicator_flag
WHERE tempAggr.id = tempTableAlias.id;
 
select * from updatetable

Q1JFQVRFIFRBQkxFIHVwZGF0ZXRhYmxlKAogICAgaWQgSU5URUdFUiwKICAgIG5hbWUgVkFSQ0hBUigxMDApLAogICAgaW5kaWNhdG9yX2ZsYWcgQ0hBUigxKQopCgpDUkVBVEUgVEFCTEUgb3RoZXJ0YWJsZSgKICAgIGlkIElOVEVHRVIsCiAgICBuYW1lIFZBUkNIQVIoMTAwKSwKICAgIGluZGljYXRvcl9mbGFnIENIQVIoMSkKKQoKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDEsJ1RlcmFkYXRhJyxudWxsKTsKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDIsJ0RhdGFiYXNlJyxudWxsKTsKSU5TRVJUIElOVE8gdXBkYXRldGFibGUgVkFMVUVTKDMsJ09yYWNsZScsbnVsbCk7CklOU0VSVCBJTlRPIHVwZGF0ZXRhYmxlIFZBTFVFUyg0LCdWZXJ0aWNhJyxudWxsKTsKCklOU0VSVCBJTlRPIG90aGVydGFibGUgVkFMVUVTKDEsJ1RlcmFkYXRhJywnWScpOwpJTlNFUlQgSU5UTyBvdGhlcnRhYmxlIFZBTFVFUygyLCdEYXRhYmFzZScsJ04nKTsKSU5TRVJUIElOVE8gb3RoZXJ0YWJsZSBWQUxVRVMoNSwnREIyJywnWScpOwpJTlNFUlQgSU5UTyBvdGhlcnRhYmxlIFZBTFVFUyg2LCdNWVNRTCcsJ1knKTsKClVQREFURSB0ZW1wQWdncgpGUk9NIHVwZGF0ZXRhYmxlIGFzIHRlbXBBZ2dyLAogICAgIG90aGVydGFibGUgYXMgdGVtcFRhYmxlQWxpYXMKU0VUIGluZGljYXRvcl9mbGFnID0gdGVtcFRhYmxlQWxpYXMuaW5kaWNhdG9yX2ZsYWcKV0hFUkUgdGVtcEFnZ3IuaWQgPSB0ZW1wVGFibGVBbGlhcy5pZDsKCnNlbGVjdCAqIGZyb20gdXBkYXRldGFibGU=