Re: MS SQL Question

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