UPDATE Tabelle1
SET Tabelle1.wert = [Tabelle2].[wert]
WHERE Tabelle1.wert="1"
AND Tabelle1.id = Tabelle2.id;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
>
"Adam Boczek" <adam.boczek_at_NO_SPAM_gft-solutions.de> wrote in message
news:998480345.290248_at_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 - 07:25:07 CDT
