UPDATE table2
SET column2 =
CASE
WHEN table1.column1 = 'condition 1' THEN 'new value 1'
WHEN table1.column1 = 'condition 2' THEN 'new value 2'
WHEN table1.column1 = 'condition 3' THEN 'new value 3'
ELSE table2.column2
END
FROM table2
JOIN table1 ON table2.some_column = table1.some_column
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)