Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Update statment in Oracle

Update statment in Oracle

From: Adam Boczek <adam.boczek_at_NO_SPAM_gft-solutions.de>
Date: Mon, 27 Aug 2001 11:45:51 +0200
Message-ID: <998905644.129215@tux2.ham.acs-gmbh.de>


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



Adam Boczek
IT Consultant
GFT Solutions GmbH
adam.boczek_at_gft-solutions.de
Received on Mon Aug 27 2001 - 04:45:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US