SQL & PL/SQL

Hi all,

I am getting this error with my script.

ORA-01767: UPDATE ... SET expression must be a subquery

CAn anyone help.

Thanks in advance.

Superkav
----------------------

UPDATE TOCPARTYADDRESSUSAGE_DKJUNE
SET (I_OCPOSTAD_USAGES, C_OCPOSTAD_USAGES) =
SELECT a.I_OCPOSTAD_USAGES, a.C_OCPOSTAD_USAGES
FROM (
SELECT a.I_OCPRTY_USAGES, a.I_OCPOSTAD_USAGES, a.C_OCPOSTAD_USAGES, b.C, b.I
FROM TOCPARTYADDRESSUSAGE_DKJUNE a JOIN TOCPARTYADDRESSUSAGE_DKJUNE b ON (a.I_OCPRTY_USAGES = b.I_OCPRTY_USAGES)
WHERE a.I_OCPOSTAD_USAGES IS NOT NULL
AND a.C_OCPOSTAD_USAGES IS NOT NULL
AND b.I_OCPOSTAD_USAGES IS NULL
AND b.C_OCPOSTAD_USAGES IS NULL
AND a.USAGE IN(1088000,1088001)
) x
WHERE TOCPARTYADDRESSUSAGE_DKJUNE.I = x.I
AND TOCPARTYADDRESSUSAGE_DKJUNE.C = x.C
AND TOCPARTYADDRESSUSAGE_DKJUNE.I_OCPRTY_USAGES = x.I_OCPRTY_USAGES;