I have an UPDATE query with the following general structure: UPDATE table1 SET (SELECT field FROM table2 WHERE conditions ORDER BY order_field LIMIT 1)
Is it possible to assign a default value in case no results are returned by the SELECT statement? Respectfully, Jorge Maldonado