The multi-part identifier "S.flag" could not be bound

Question

i have a two table one name is "user" and another name is "Prod".

My query is

update User_list_SQL set team=s.uteam, S.flag='Y' 
from User_list_SQL as U, SQlVal as S 
where U.name=S.uname

the error comes the following

[SQL Server]The multi-part identifier "S.flag" could not be bound.

How to write the query the above instance? please advice. Thanks

This is not possible. You can only update one table in one statement. You will have to split this out in to two statements. — Chamal Pradeep Rajapakse, Mar 04 '14 at 09:34
Hello Friend how to update? but this is possible in MS-access 2010 — A. Pandiarajan, Mar 04 '14 at 09:39

score 0 · Answer 1 · edited May 23 '17 at 10:26

0

You cannot update two tables at once. You will need to split it into 2 queries.

Follow below post..

edited May 23 '17 at 10:26

Community

answered Mar 04 '14 at 09:38

Sateesh Pagolu

1 Answers1