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
191 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
2 Comments
 
LVL 3

Accepted Solution

by:
trouta earned 100 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

706 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now