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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
