On 21 Dec 2013, at 7:45pm, Giuseppe Costanzi <[email protected]> wrote:
> I am not sure to have understood the Igor's solution > > ...SUM(stats.quantity * (stats.which_month = 1)) AS gen.... > > which is the meaning of the operator * in the statement? Multiply. It works because "stats.which_month = 1" is a boolean and therefore evaluates to either 0 or 1. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
