Re: MS SQL Question

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: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- _________________ Andrian Pervazov Web Developer T 727.502.4537 F 727.823.6523 apervazov@aspenmg.com www.aspen-interactive.com