Re: UPDATE with multiple WHERE conditions

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

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