Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Update statment in Oracle
I have two tables:
table1 with fields "id" and "x"
table2 with fields "id" and "x"
I'd like to update value of field "x" from table1 with value of field "x" from table2 where "id" of table1 = "id" od table2. I've try this statement:
UPDATE table1
SET table1.x = table2.x
WHERE table1.id = table.id;
but I always receive error that the name of feld is not correct. How can
write such easy statement? In Access I've used "left join" and so on without
any problems...
Help
Greets,
Adam