SQL Help

I'm running Oracle 8

I've got an update query:

update TABLE_A a

    set a.COL_1 = (select COL_2 from TABLE_B b where a.COL_3 = b.COL_3);

If the subquery returns NULL, I want to leave a.COL_1 unchanged i.e. not set it to null. How do I do this? Received on Fri May 07 1999 - 11:24:31 CDT