Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Can you specify multiple tables in update's where clause?
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 Wed May 23 2001 - 23:37:18 CDT