Ryan:
Try it like this:
UPDATE common, extended
SET common.[Extended Description] = extended.[Extended Description]
WHERE common.[id] = extended.[Extended Description]
Saludos,
Pablo
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Wednesday, February 07, 2001, 9:26:03 AM, Ryan wrote:
CR> I am trying to update a table with data from another table within the same
CR> database with the following SQL
CR> UPDATE common SET common.[Extended Description] = extended.[Extended
CR> Description] WHERE common.[id] = extended.[Extended Description]
CR> the id is the primary key. I keep getting the following error.
CR> Server: Msg 107, Level 16, State 3, Line 1
CR> The column prefix 'extended' does not match with a table name or alias name
CR> used in the query.
CR> Server: Msg 107, Level 16, State 1, Line 1
CR> The column prefix 'extended' does not match with a table name or alias name
CR> used in the query.
CR> Anyone have any ideas.
CR> Ryan
--
PHP Windows 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]
