UPDATE TableA SET nrA = TableB.nrB WHERE nrA = TableB.nrA;
UPDATE statements don't take FROM clauses. I don't think they like aliasing, either.
----- Original Message -----
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