Nope, that's not the problem. it is related to the syntax.
He is trying to refer to a table that is not "declared" in the statement,
that is an illegal thing to do. What he simply is trying to do (with all the
crap cut way) is:
UPDATE A SET A.b = B.d
WHERE A.a = B.c
Nowhere is the table B declared, so the query parser run confused, and
reports back:
"The column prefix 'extended' does not match with
a table name or alias name NOT USED IN THE QUERY"
The parser reports this error twice, since the reference to the "undeclared"
table are found twice. In principle the parser simply says: RTFM!
Happy hacking,
Anders
>-----Original Message-----
>From: Foley, John [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 07, 2001 7:15 PM
>To: 'Conover, Ryan'; [EMAIL PROTECTED];
>[EMAIL PROTECTED]
>Subject: [PHP-WIN] RE: MS SQL Question
>
>
>
>
> The table or view "extended" does not exist in the
>declared database
>context. If this table or view is in another database on the
>same server,
>use database.table.column (not sure about exact syntax here)
>
>
> John T. Foley
> Network Administrator
> Pollak Engineered Products, Actuator Products Division,
>A Stoneridge
>Company
> 195 Freeport Street, Boston MA 02122
> ph: (617) 474-7266 fax: (617) 282-9058
>
> The geographical center of Boston is in Roxbury. Due north of
>the center we find the South End. This is not to be confused with South
>Boston which lies directly east from the South End. North of the South
>End is East Boston and southwest of East Boston is the North End.
>
>
>
>> -----Original Message-----
>> From: Conover, Ryan [SMTP:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 07, 2001 10:26 AM
>> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>> Subject: MS SQL Question
>>
>> 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 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]
