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

> 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
>
>
Thanks Tom,

I did try a lot myself, taking different appraoches and  structures and
different queries. Together with your tip's I changed it finally this
morning to:

update b1_telco
    set  telnr = n.telnr
    from
    b1_telco as t inner join b1_naam as n on t.relcode = n.relcode
    where
        n.naam like 'Bakk%';

and it still has flaws.

Observations:
a. *All* records were affected  instead of those specified in the
where-clause.
b. the value to which the field is set (set  telnr = n.telnr), is the
same for all affected records. My intention was to copy the
corresponding fields.
c. there are no sql errors:  Query returned successfully: 10246 rows
affected, 422 ms execution time.

I'd very much like to hear the response(s).

Balvie