Hi,
I use: Postgres 7.3.10 and Pgadmin 1.4.3 on RH Linux
I got 2 tables with names and telephone numbers:
CREATE TABLE b1_naam
(
relcode varchar(10),
naam varchar(100),
telnr varchar(30)
)
CREATE TABLE b1_telco
(
relcode varchar(10),
telnr varchar(30),
ppc varchar(25)
)
and I need to restore some data. I created something like:
UPDATE b1_naam
SET telnr = t.telnr
FROM b1_telco as t
WHERE
b1_naam.relcode = b1_telco.relcode AND
b1_naam.naam like 'Bakke%';
Can anyone tell me what I did wrong? I have seen very complicated
statements with nested selects. I cannot believe that a simple query,
like the one I wrote above, is not available.
Thanks,
Balvie