Update query with join between two tables alternative since Postresql does not support join in update query.

suggest change

update <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.

Postgres Tips and Tricks:

*DATEADD alternative in Postgres

*Comma seperated values of a column

*Delete duplicate records from postgres table

*Update query with join between two tables alternative since Postresql does not support join in update query.

*Difference between two date timestamps month wise and year wise

*Query to CopyMoveTransafer table data from one database to other database table with same schema