Update Querry and NULL values

Hi All!

Another question. I have to do an update to a table in oracle 8i where the values of the column are null.

The issues I think is that there is no relationship setup between one of the tables.

Here is PART of the query:

UPDATE TABLE_1
SET COLUMN_1 =
(
SELECT A.TASKID
FROM DEV.TABLE_1 A
WHERE EXISTS (SELECT B.TASK_ID
FROM DEV2.TABLE_1 B
WHERE A.TASKID = B.TASK_ID
AND A.DESCRIPTION = B.TASK_NAME)
)

This is were I am stuck. The update needs to occur when the values in TABLE_1.COLUMN_1 IS NULL. The table TABLE_1 does not have a realtionship to either DEV.TABLE_1 or DEV2.TABLE_1.

Any insight we be greatly appreciated. Also any suggested books on Database Design and Data Anaylsis using SQL.

Thanks!

Kevin Received on Tue Oct 23 2001 - 15:42:10 CEST