Why don't you just use a subquery?

rbv


> No. However, you can create a VIEW which joins tables (which would need
> a primary key) and then you can us the update statement on the VIEW.
>
> Eric
>
>
> -----Original Message-----
> From: Derrick Pitts
> [mailto:oracledba-ezmlmshield-x37445532.[Email address protected]
> Sent: Wednesday, November 30, 2005 9:20 AM
> To: LazyDBA Discussion
> Subject: Update statement
>
> 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
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page