SQL UPDATE problem.... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL UPDATE problem....

Author

Topic

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-02-16 : 11:58:22

I need to set the value of one field in one database with the value of another field in another database like so......

UPDATE
Proteus..tbl_Inst_Address
SET
fi_iData_AddressCode = iData_Holding..FMG_Address.FMG_Address_Code

WHERE
iData_Holding..FMG_Address.FMG_Address_Status = 2
AND
iData_Holding..FMG_Address.Upload_Status_Code = 'U'
AND
iData_Holding..FMG_Address.Active = 1

when trying to run the above i get the following messages:-

Server: Msg 107, Level 16, State 3, Procedure usp_iDataToProteus_trn, Line 38
The column prefix 'iData_Holding..FMG_Address' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Procedure usp_iDataToProteus_trn, Line 38
The column prefix 'iData_Holding..FMG_Address' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Procedure usp_iDataToProteus_trn, Line 38
The column prefix 'iData_Holding..FMG_Address' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Procedure usp_iDataToProteus_trn, Line 38
The column prefix 'iData_Holding..FMG_Address' does not match with a table name or alias name used in the query.

It seems to narrow down to a problem with the line in the SET statement but i can't quite put my finger on it. All DB and table names are correct.

Can someone shed some light please.....thanks

Edited by - KnooKie on 02/16/2001 12:02:07

shijobaby
Starting Member

44 Posts

Posted - 2009-08-20 : 03:04:13

the column prefix does not match with a table name or alias name used in the query.

I was also working to solve this error

Nw i found why it is comming just needs to make small changes in query

http://sqlerrormessages.blogspot.com/2009/08/sql-server-error-messages-msg-107.html

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources