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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
