UPDATE A with B
From: Henrik Rusche <rusche_at_iw.uni-hannover.de>
Date: Fri, 12 Feb 1993 18:35:38 GMT
Message-ID: <1993Feb12.183538.1002_at_newsserver.rrzn.uni-hannover.de>
Date: Fri, 12 Feb 1993 18:35:38 GMT
Message-ID: <1993Feb12.183538.1002_at_newsserver.rrzn.uni-hannover.de>
Hey,
here's a problem I would like have to solve only with SQL.
There are two tables (A,B) with the same structure. Let's say
nr number (3), primary key
Now I want to update A with B following this schema :
A.Text = B.Text if A.nr = B.nr
My first try :
UPDATE A
With PL/SQL it's simple.
text char (50)
SET A.Text = B.Text
WHERE A.Nr = B.Nr;
But that's no solution. Is there a solution - If not why ??????
-Henrik
Henrik Rusche Ronnenbergerstrasse 28 Institut fuer Werkstoffkunde 3000 Hannover 91 Uni Hannover rusche_at_iw.uni-hannover.deReceived on Fri Feb 12 1993 - 19:35:38 CET
-----------------------------------------------------------------------