I have these 3 queries
SELECT max(area_aut) from autorizaciones where id = 'Variable a buscar' and Area = 'A'
SELECT max(area_aut) from autorizaciones where id = 'Variable a buscar' and Area = 'B'
SELECT max(area_aut) from autorizaciones where id = 'Variable a buscar' and Area = 'C'
How could I make it a single query since I need to update a table, but I don't know how to do it in a single query
This is one way: