Re: UPDATE with multiple WHERE conditions

[Rich Shepard]

On Wed, 12 Jun 2024, Ron Johnson wrote:

A plain UPDATE might work.

UPDATE to_be_updated a
SET bool_col = true
FROM other_table b
WHERE a.pk = b.pk
 AND b.field3 = mumble;

(You can join them, right?)

Thanks, Ron.

Rich