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:[EMAIL PROTECTED]]
>Sent: Wednesday, February 07, 2001 4:28 PM
>To: [EMAIL PROTECTED]
>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: [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]
