I've been meaning to ask this myself. I've been writing it like
update TableA set Field2 = (select Field4 from TableB where Field3 = TableA.Field1) where Field1 = ?; --perhaps But it feels wrong. -Clark ----- Original Message ---- From: Greg Robertson <trifus...@gmail.com> To: sqlite-users@sqlite.org Sent: Monday, February 23, 2009 3:34:15 PM Subject: [sqlite] UPDATE Field based on matching value in different Table 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users