|
Auris
Starting Member
United Kingdom
7 Posts |
 Posted - 05/23/2012 : 06:52:35
|
hi guys, i have this sql update statement written and i dont understand how it acually knows which record/s to update. Its from the production and its working correctly for 4 years, the problem is we are implementing some changes and now i need to udpate it.
UPDATE RiskSubjectivity
SET RiskId = e.RiskId
FROM RiskCorrespondence rc
JOIN Endorsement e
ON e.AppliedToRiskId = rc.RiskId
WHERE e.RiskId = @RiskId
the question is how does it determines which RiskSubjectivity row to update since no join is applied to it? i have written update and delete joins but i have never seen one like this.
explanation or an article on the topic would be good.
Thank you
Life is hard. It's even harder if you're stupid. |
|
explanation of sql
