>update locations > set ItemCount='1' > where exists( > select Location from hive where locations.Location=hive.Location > )
Okay, seems that I wasn't too far off. Thank you very much for the help, I certainly needed it:):) >update locations > set ItemCount='0' > where NOT exists( > select Location from hive where locations.Location=hive.Location > ) I must be having a brain fade day, was sure that I had tried this. Ah well, living and learning as much as I can. Thanks once again. -- View this message in context: http://old.nabble.com/Update-one-table-from-matches-in-another-tp32232409p32233295.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