Trying to find a way to update a bunch of records in the request table by changing request_taken_time to a value in another table. The problem is, there are multiple records in the history table so there will be duplicate queries and it may not get the most recent time which is what is wanted. I can’t use group by on an update and if I can’t use group by then I can’t use the MAX function. So it will basically update the records multiple times and won’t get the highest value like I need it to.