Cacher is the code snippet organizer for pro developers

		With fromTable As (
		  select field1 from tbl
		)
		Update tableName
		Set tn.field1 = fromTable.field1
		From tableName tn
		Inner Join fromTable on tn.field=fromTable.field;