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

Reply via email to