SQL Server: How to modify data in any table in a resultset made up of

Recently i'm seeing a lot of questions about how to modify data in the tables which are part of the multi-join select statement. And i keep wondering how can this be so hard to remember. The methodology is quite simple.