Re: MS SQL Question

The table "extended" is not known to the update command. You shoud use a syntax like this: UPDATE table1 SET table1.field1 = (select field2 from table2 where table2.id=table1.id). - Frank >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 > > >