[code
update personal set status = (select status from kunde where personal.id=kunde.id);
[/code]
nicht ganz Deine Spaltennamen, das überlasse ich Dir zur Übung.
Beispiel:
test=# create table personal (id int);
CREATE TABLE
test=*# create table kunde (id int, status int);
CREATE TABLE
test=*# insert into kunde (id,status) values (1,1);
INSERT 0 1
test=*# insert into kunde (id,status) values (2,2);
INSERT 0 1
test=*# insert into kunde (id,status) values (3,3);
INSERT 0 1
test=*# insert into personal (id) values (1);
INSERT 0 1
test=*# insert into personal (id) values (2);
INSERT 0 1
test=*# insert into personal (id) values (3);
INSERT 0 1
test=*# commit;
COMMIT
test=# alter table personal add column status int;
ALTER TABLE
test=*# update personal set status = (select status from kunde where kunde.id=personal.id);
UPDATE 3
test=*# select * from personal ;
id | status
----+--------
1 | 1
2 | 2
3 | 3
(3 rows)