[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

Reply via email to