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>


Hey,

here's a problem I would like have to solve only with SQL.



With PL/SQL it's simple.

There are two tables (A,B) with the same structure. Let's say

  nr number (3), primary key
  text char (50)

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
   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.de 

-----------------------------------------------------------------------
Received on Fri Feb 12 1993 - 19:35:38 CET

Original text of this message