Let's suppose that I have an UPDATE query which includes a SELECT as part
of it as follows:
UPDATE table1
SET field1 = (SELECT fieldx FROM table2 WHERE .........)
What happens if the result of the SELECT command does not return any row?
Respectfully,
Jorge Maldonado