Hi All,
the synchronized update, which I was used to using in Oracle, does
not work properly on a FB 1.5 Server!

I have two tables:
tab1:
customer_id integer,
name varchar(100),
email varchar(50))

tab2:
customer_id integer
email varchar(50))

They contain the following values:
tab1:
10000 'McDonald' 'DEFAULT@...'
10001 'OReilly' 'DEFAULT@...'
10002 'McPherson' 'DEFAULT@...'

tab2:
10000 'INFO@...'

As soon as I want to update a certain number of rows in tab1 with a
certain value from tab2 with the following synchronized update, the
field 'email' from the rows of tab1, which doesn't match with the
rows of tab2 via customer_id, is NULLIFIED:

tab1:
10000 'McDonald' 'INFO@...'
10001 'OReilly' <null>
10002 'McPherson' <null>

This is the update-statement:

update tab1 t1
set email =
(
select t2.email from tab2 t2 where t1.customer_id = t2.customer_id
);
commit;

What is my mistake?

Regards, Christoph