Posted by Jeffrey Sheldon via SQLMonster.com on 10/01/73 11:22

I have one field organization_operating_name that is on two tables vendor and
vendor_loc

I want to update the vendor name to the vendor_loc name

I tried this but get errors...


update vendor_loc
set organization_operating_name = vendor.organization_operating_name
where organization_operating_name like 'DO NOT%'

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

vendor is a valid table name...so I must be missing something.

jeff


--
Message posted via http://www.sqlmonster.com

• Next in forum: Re: Easy question on UPDATE
• Prev in forum: Re: Anything that you find in SQL object scripts, you can also find them in system tables?
• Thread view: Easy question on UPDATE

[Reply to this message]