Re: Simple SQL-syntax

----- Original Message -----

From: Fredrik Thunberg

To: pgsql-sql@postgresql.org

Sent: Monday, August 20, 2001 6:15 AM

Subject: Simple SQL-syntax

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 = B.nrB From tableB B Where tableA.nrA = B.nrA;

 

But that doesn't seem to work...

 

Best regards

 

/Fredrik Thunberg