hi,
when i try to do this

update table1 set table1.col1=
(select table2.col2 from table2 where table2.col2=table1.col2)

now it does update the rows that do match however it sets all the
other
rows to nul
even if that col1 in table1 was defined as not null.

this is on ib6.01 under win2k....& this is possibily the bizzarest
thing ive
ever seen a database do
could anyone else confirm this please ? the above happens in ibconsole
& also when using ibo.
& suggest a workaround

thanks
pete