missing FROM-clause entry for table "subquery"

So I am trying to update a row while using a subquery for it but getting erro all the time
Screenshot_2024-08-29_at_20.23.20.png
Was this page helpful?