You don't have a FROM clause. Something like this should work:
UPDATE common
SET common.[Extended Description] = extended.[Extended Description]
FROM common,extended
WHERE common.[id] = extended.[Extended Description]
"Conover, Ryan" wrote:
>
> 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 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]
--
_________________
Andrian Pervazov
Web Developer
T 727.502.4537
F 727.823.6523
[EMAIL PROTECTED]
www.aspen-interactive.com
--
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]
