I am taking a deviation from the series of posts I am doing for Recovery Concepts and Implementation. I have already posted two in that series. This one has to come, cause I was recently discussing with some developers and they were having tough time dealing with updates to data based on/using data from some other source table. I realized, people generally do not know all the capabilities of an Update statement. The form they know is