Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update a table with a Join

Status
Not open for further replies.

jbenson001

Programmer
Jan 7, 2004
8,172
US
remove the alias "B" from this line
Code:
update Base B
 
I get the following error when doing that:

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "B.Status" could not be bound.
 
I'd have said to do it the other way around and remove the 'Base' part.

Code:
update B
 


Try

update Base
set Status='T'
from QA a
join Base b on a.ACCTNUM = b.PatAcctNo


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach
 
Please post your solution as it might help others.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top