MS SQL Question
| From: | Conover, Ryan | Date: | Wed, 07 Feb 2001 15:26:03 +0000 |
| Subject: | MS SQL Question | ||
| Groups: | php.general php.windows | ||
| Request: | Send a blank email to php-general+get-38543@lists.php.net to get a copy of this message | ||
I am trying to update a table with data from another table within the same
database with the following SQL
UPDATE common SET common.[Extended Description] = extended.[Extended
Description] WHERE common.[id] = extended.[Extended Description]
the id is the primary key. I keep getting the following error.
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'extended' does not match with a table name or alias name
used in the query.
Server: Msg 107, Level 16, State 1, Line 1
The column prefix 'extended' does not match with a table name or alias name
used in the query.
Anyone have any ideas.
Ryan