Re: UPDATE the field of a table with fields from another table

Balvie <ener@ibb.nl> writes:
> UPDATE b1_naam
>    SET telnr = t.telnr
>    FROM b1_telco as t
>    WHERE
>      b1_naam.relcode = b1_telco.relcode AND
                         ^^^^^^^^ should be t
>      b1_naam.naam like 'Bakke%';

Less-obsolete versions of Postgres would have warned you about this,
or even reported it as an error.

            regards, tom lane