RE: [PHP-WIN] MS SQL Question

Dear Pablo: You are thinking right (try to give a reference to the table), but your suggestion will most likely generate a "syntax error" message, since the standard syntax (ISO SQL) wont allow such a construction. >-----Original Message----- >From: Pablo Vera [mailto:pvz@vercan.com] >Sent: Wednesday, February 07, 2001 4:28 PM >To: php-windows@lists.php.net >Subject: Re: [PHP-WIN] 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 > > > >-- >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 >