Viewing 2 posts - 1 through 2 (of 2 total)
You can use an UPDATE FROM to accomplish this.
For example:
UPDATE Polling
SET Polling.X = VC.X, Polling.Y = VC.Y
FROM PollingCenters AS Polling
LEFT OUTER JOIN VotingCenters VC ON Polling.CodePlace = VC.CodePlace
This will...
October 26, 2010 at 12:14 pm
#1242490
No, the relationship will be between table3 and whatever table(s) you put after the ON clause.
October 26, 2010 at 7:18 am
#1242235