How to use a select pivot query to update two different tables
I'm not 100% sure to understand your question but if you are looking at doing and UPDATE from a SELECT, then you may want to look at this.