>You can do both in one pass: >update locations set ItemCount = >case when Location in (select Location from hive) > then '1' else '0' >end;
Thanks for your help Igor, extremely elegant solution. -- View this message in context: http://old.nabble.com/Update-one-table-from-matches-in-another-tp32232409p32233560.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
