在MySQL中使用两次子查询的结果

I'm creating a trigger to update one table upon the insertion of a row in another table. In this update statement, I need to select a value from the first table. I need to then use this selected value in two places in the update statement. Here's the trigger statement I have now:I'm creating a trigger to update one table upon