ROTECTED]]
>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 comm
inal Message-
>From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 07, 2001 4:26 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: [PHP-WIN] MS SQL Question
>
>
>I am trying to update a table with data from another table
>within the same database wit
You don't have a FROM clause. Something like this should work:
UPDATE common
SET common.[Extended Description] = extended.[Extended Description]
FROM common,extended
WHERE common.[id] = extended.[Extended Description]
"Conover, Ryan" wrote:
>
> I am trying to update a table with data from ano
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:
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
