I have two tables each with two fields: TableA: Field1, Field2
TableB: Field3, Field4 I would like to set Field2 in TableA to the value in Field4 in TableB where TableA.Field3=TableB.Field4 Sounds simple enough but I can't figure out how to write the UPDATE SQLite for this. Can someone help? Thanks Greg _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users