Received: from chrome.datessa.se (chrome.datessa.se [192.121.160.17]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7KBFaP76608 for ; Mon, 20 Aug 2001 07:15:37 -0400 (EDT) (envelope-from fredrik@datessa.se) Received: from ctunis (c-tunis.intern.datessa.se [10.0.0.113]) by chrome.datessa.se (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id NAA17274 for ; Mon, 20 Aug 2001 13:15:33 +0200 X-Authentication-Warning: chrome.datessa.se: Host c-tunis.intern.datessa.se [10.0.0.113] claimed to be ctunis Message-ID: <01a501c12969$6e397a10$7100000a@intern.datessa.se> From: "Fredrik Thunberg" To: Subject: Simple SQL-syntax Date: Mon, 20 Aug 2001 13:15:33 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01A2_01C1297A.31B18130" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200108/239 X-Sequence-Number: 4471 This is a multi-part message in MIME format. ------=_NextPart_000_01A2_01C1297A.31B18130 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello. I have a very simple sql-question from an sql-beginner: Suppose I have Table A looking something like this: Index Text NrA And Table B like this: NrA NrB Then I want to change all occurences of NrA in Table A to NrB... I've tried: UPDATE tableA Set tableA.nrA =3D B.nrB From tableB B Where tableA.nrA =3D B= .nrA; But that doesn't seem to work... Best regards /Fredrik Thunberg ------=_NextPart_000_01A2_01C1297A.31B18130 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello.
 
I have a very simple sql-question from&nbs= p;an=20 sql-beginner:
 
Suppose I have Table A looking something l= ike=20 this:
 
Index    Text  &n= bsp;=20 NrA
 
And Table B like this:
 
NrA    NrB
 
Then I want to change all occurences of Nr= A in=20 Table A to NrB...
 
I've tried:
 
UPDATE tableA Set tableA.nrA =3D B.nr= B From=20 tableB B Where tableA.nrA =3D B.nrA;
 
But that doesn't seem to work...
 
Best regards
 
/Fredrik Thunberg
------=_NextPart_000_01A2_01C1297A.31B18130--