update a set location='new york ' where a.location isnull and a.mz_tik in(select mz_tik from c);
-- View this message in context: http://old.nabble.com/updating-table-only-if-key-match-in-other-table-tp32873978p32873978.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
