Gurus,

I need a little help with an update statement. I'm trying to create an
update statement that joins a table. Will something like this work?

update plmqa.ecs_activity
(SELECT a.ecsactivities_uid
FROM plmqa.ecs_task a, plmqa.ecs_activity b
WHERE a.ecsactivities_uid = b.ecsactivities_uid
AND UPPER (ecsactivities_subject) LIKE '%DELL%')
SET ECSACTIVITIES_UPDATED_DATE = sysdate,
ECSACTIVITIES_UPDATED_BY = '0',
ECSACTIVITIES_STATUS = '0'
where ECSACTIVITIES_STATUS = '1' and ECS_CREATED_BY = '0';

Derrick Pitts, OCP
Database Administrator
Palm Harbor Homes, Inc.
972-764-9403

Oracle LazyDBA home page