Gussimulator <[EMAIL PROTECTED]> wrote: > 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??
When the condition holds in both tables, which one are you supposed to update? Do you need to update both? You could do the latter simply by running two almost-identical UPDATE statements, one against each table. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users