'mandatory not null' dilemma

From: <damon_short_at_aon.com>
Date: Tue, 25 May 1999 19:35:40 GMT
Message-ID: <7ieu2c$bgb$1@nnrp1.deja.com>

This was addressed awhile back, but I still don't understand why the following won't work:

UPDATE table_2
SET (column_1,column_2)=
(SELECT column_1,column_2 from table_1
where table_1.column_1=table_2.column_1 and table_2.column_2=table_2.column_2)

These are 'not null' fields, but NONE OF THE ROWS IN table_1 are NULL.

yet I get:
ORA-01407: cannot update mandatory (NOT NULL) column to NULL

There has to be some syntax I'm missing, and I'm relatively new to Oracle, so any insight is greatly appreciated.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 14:35:40 CDT