Without more info, here's the general approach: UPDATE c SET int_field = int_field+1 WHERE (table a condition) OR (table b condition)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gussimulator Sent: Monday, February 04, 2008 1:57 PM To: sqlite-users@sqlite.org Subject: [sqlite] Update value from either database table? I have a field I need to update given a condition, but I don't know wether the condition occurs in table A or table B, how can I perform this query? I have 2 identical tables in design, but one contains system data and the other one contains user data... On my update routine (in C) I have to increase an INTEGER field from either table given a condition... The thing is, the condition could be present on both tables... what should I do?? Thanks! _______________________________________________ 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