SQL更新查询 - 聚合可能不会出现在UPDATE语句的集合列表中

I'm trying to write a query that updates tbl8_update_transactions HID field (where it's null) with the primary key value (HID) that's highest in HOLIDAY_DATE_TABLE. I get the following error I'm trying to write a query that updates tbl8_u