This looks to work fine and runs fast as well, combining the 2 queries I have now:
UPDATE QR3PARAMS SET ED = CASE WHEN ID IN (SELECT ID FROM PROBLEMS WHERE READ_CODE GLOB 'Eu522*' OR READ_CODE GLOB 'E2273*' OR READ_CODE = '1777409015') OR ID IN (SELECT ID FROM CURRENT_MED WHERE TERM_TEXT GLOB 'Sildenafil*' OR TERM_TEXT GLOB 'Tadalafil*' OR TERM_TEXT GLOB 'Vardenafil*') THEN 1 ELSE 0 END RBS On Wed, Nov 13, 2019 at 9:09 PM Peter da Silva <res...@gmail.com> wrote: > > > > This almost seems like a job for a view. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
