Hi Ryan,
You could try REPLACE INTO in combination with a select from the second
table, instead of UPDATE.
For the exact syntax see http://www.mysql.com/doc/R/E/REPLACE.html
Maybe you can fit it to your needs.
Wieger
"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 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]
--
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]
