Access -> Oracle - easy but urgent

From: Adam Boczek <adam.boczek_at_NO_SPAM_gft-solutions.de>
Date: Wed, 22 Aug 2001 13:37:49 +0200
Message-ID: <998480345.290248@tux2.ham.acs-gmbh.de>

How this statement (written in Access):

UPDATE Tabelle1
INNER JOIN Tabelle2 ON Tabelle1.id = Tabelle2.id SET Tabelle1.wert = [Tabelle2].[wert]
WHERE (((Tabelle1.wert)="1"));

should look in Oracle SQL (8i)?

Help :-)

Greets,
Adam

---

Adam Boczek
IT Consultant
GFT Solutions GmbH
adam.boczek_at_gft-solutions.de

---

Received on Wed Aug 22 2001 - 06:37:49 CDT