David Raymond, on Wednesday, November 13, 2019 10:34 AM, wrote... > > "Why is ED changed to '' or NULL for ID 5?" > > When you update to a subquery which returns no rows, then the field gets > updated to null.
So, I have to address "no matches or no rows returned" in another subquery. Huh! Muchas gracias. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users