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
Syntax (simplified)
UPDATE
SET = {expression | DEFAULT | NULL}
FROM [,...n]
WHERE
In the "FROM ... WHERE ..." construction is where you should place the
"other" table and the appropriate search conditions.
You can try this script to get a grip of it:
create table A (a int, b int)
create
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:
