Re: MS SQL Question

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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net