Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2001-08-07
2
Medium Priority
?
244 Views
Last Modified: 2008-03-06
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.
0
Comment
Question by:Paninaro080701
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
trouta earned 400 total points
ID: 6360787
Try this
Update A
set A.a = B.c, A.b = B.d
from b
where A.x = B.y
0
 

Author Comment

by:Paninaro080701
ID: 6360804
Excellent!  Thank you.

Luke.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question