Re: [PHP] MS SQL Question

2001-02-07 Thread Frank M. Kromann
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

Re: [PHP] MS SQL Question

2001-02-07 Thread Wieger Uffink
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 ano

[PHP] MS SQL Question

2001-02-07 Thread Conover, Ryan
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