On Sat, Oct 16, 2010 at 2:47 AM, Jim Morris <jmor...@bearriver.com> wrote:
> Not much help but this removes the multiplication: > SELECT B1.B + B2.B + B3.B + B4.B FROM > (SELECT 0 AS B UNION SELECT 1 AS B) AS B1, > (SELECT 0 AS B UNION SELECT 2 AS B) AS B2, > (SELECT 0 AS B UNION SELECT 4 AS B) AS B3, > (SELECT 0 AS B UNION SELECT 8 AS B) AS B4 > > thanks, Jim, thinking "binary" sometimes makes things more complicated than it could be :) Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users