I have the following query: SELECT MIN(totalUsed) - 1 FROM quotes WHERE totalUsed <> 'notUsed'
What I want is that when the SELECT returns a positive value every record where totalUsed <> 'notUsed' is lowered with the returned value. Is easy to accomplish in programming code, but I was wondering if this could be done with a SQL statement. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
