Update A set A.a = B.c, A.b = B.d where A.x = B.y - Why Can't I?

Why won't SQL let me do this (apart from the obvious error message) and how can I get around it?

Thanks so much!!

Luke.
Paninaro080701Asked:
Who is Participating?
 
troutaCommented:
Try this
Update A
set A.a = B.c, A.b = B.d
from b
where A.x = B.y
0
 
Paninaro080701Author Commented:
Excellent!  Thank you.

Luke.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.