[SQL] Re: Simple SQL-syntax

[Jeff Eckermann]

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 ----- From: Fredrik Thunberg To: [EMAIL PROTECTED] 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