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 General 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]
