Re: Can you specify multiple tables in update's where clause?
Date: Sat, 21 Jul 2001 21:07:38 GMT
Message-ID: <9eifm3$6vfma$1_at_reader01.wxs.nl>
Try this
update table_a
And buy an SQL-book.
change <changeme_at_changeme> schreef in berichtnieuws
9ei2f5$dh01_at_kcweb01.netnews.att.com...
set table_a.my_col = 'Like This'
where table_a.col_a in
(select table_x.col_b
from table_x
, table_y
where table_x.col_x= table_y.col_d
)
> 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:38 CEST