UPDATE

UPDATE

• UPDATE with condition from other table fields

Condition-Update

   UPDATE TABLE1 SET field1 = value1 FROM TABLE2
   WHERE split_part(TABLE2.fieldA,'-',1) = split_part(TABLE1.fieldB,'-',1);