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 <[email protected]> wrote: > > > > This almost seems like a job for a view. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
