Updating using Join statement in Oracle

[tcarew333]

Is there anyone who can help me convert this statement to Oracle Standards????

Update ASEmployee
SET ASEmployee.CALLEMPNO = Null,
ASEmployee.TREEID =Null,
ASEmployee.dOrder = Null,
INDENT = NULL,
ROWNO = NULL,
VLINE = NULL,
NTFYEMPNO = NULL,
NTFYAREA = NULL
FROM ASEmployee
LEFT JOIN EMPLOYEE ON
ASEmployee.CALLEMPNO = EMPLOYEE.EMPNO
WHERE
(ASEmployee.CALLEMPNO Is Not Null)
AND
(EMPLOYEE.EMPNO Is Null)
UPDATE ASEmployee
set NTFYEMPNO = NULL,
NTFYAREA = NULL
FROM ASEmployee
LEFT JOIN EMPLOYEE ON
ASEmployee.NTFYEMPNO = EMPLOYEE.EMPNO
WHERE
(ASEmployee.NTFYEMPNO Is Not Null) AND (EMPLOYEE.EMPNO Is Null)

[marist89]

this forum is for administriva. Please post your question in the "Database Administration" OR "Development" forum.