如何在更新中生成select语句？

I need to update a table, and the Where clause should contain the last (or max) from a certain column, so I made this query:I need to update a table, and the Where clause