Re: Can you specify multiple tables in update's where clause?

hi,

u cannot give multiple tables in the update command, but u can use a sub-query as a where clause... example...

update emp set sal = 100 where
deptno = (select deptno from dept where dname = 'SALES');

hope this helps...

regards,
aparna

"change" <changeme_at_changeme> wrote in message news:9ei2f5$dh01_at_kcweb01.netnews.att.com...
> Need some sql expert input on UPDATE command. How do I involve multiple
> tables in WHERE clause?
>
> Consider this simplified example on update command:
>
> UPDATE TABLE_A
> SET TABLE_A.my_col = "thisThat"
> WHERE
> TABLE_A.col_a = TABLE_X.col_b
> and TABLE_X.col_c = TABLE_Y.col_d
>
>
> This fails with a message that table2 is not in scope! How do I involve
> multiple tables in the where clause of an update? Can't seem to find an
> example in any book/webpage.
>
> Comments?
>
> essbee
>
> (I am using Oracle 8.1.5, though this seems to be a generic SQL question)
>
>
Received on Sat Jul 21 2001 - 23:07:45 CEST