Ah I realize now I didn't write it out in the example, but by thing and thing2 I just allegorically wanted to represent a *very complex* subselect, so here we go more clearly:
Inlining this subselect's SQL expression in the "A / B" part would make it need to execute once more, which would make it take double the time, which would be really long. So again, SELECT id, (SELECT [very complex subselect here, that uses categories.id as input]) AS a, (SELECT [another very complex subselect here, that uses categories.id as input]) AS b, a / b AS c FROM categories ORDER BY c; any way to do it whatsoever? Thanks :)) Mikael 2013/7/20 Luuk <luu...@gmail.com> > > SELECT > id, > othertable.thing as a, > othertable2.thing as b, > othertable.thing/othertable2.**thing as c > FROM categories > INNER jOIN othertable ON othertable.something = categories.id > INNER JOIN othertable2 ON othertable2.something2 = categories.id > ORDER BY c; > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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
