"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. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users