Update query with join between two tables alternative since Postresql does not support join in update query.
suggest changeupdate <SCHEMA_NAME>.<TABLE_NAME_1> AS A
SET <COLUMN_1> = True
FROM <SCHEMA_NAME>.<TABLE_NAME_2> AS B
WHERE
A.<COLUMN_2> = B.<COLUMN_2> AND
A.<COLUMN_3> = B.<COLUMN_3>
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents