Update a table with a Join

[jbenson001]

remove the alias "B" from this line

update Base B

 

[jconway]

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.

 

[starsky51]

I'd have said to do it the other way around and remove the 'Base' part.

update B

 

[MarkSweetland]

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

 

[jconway]

Have it working. Thanks for the help!

 

[djj55]

Please post your solution as it might help others.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!