RE: Simple SQL-syntax

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Probably something like:

UPDATE tableA SET tableA.nrA = (SELECT B.nrB FROM tableB B WHERE
tableA.nrA = B.nrA);

Let me know...


MikeA

- -----Original Message-----
From: Fredrik Thunberg [mailto:fredrik(at)datessa(dot)se]
Sent: 20 August 2001 12:16
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] 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

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO4EtanympNV/C086EQKOMwCbBLcLCUJYK5gWvOROp2IbV0+IkC4An1gN
0Bys7MmGO9C6S6o8nt1YPwRQ
=Vhvj
-----END PGP SIGNATURE-----