personalt wrote: > Is there a way to inside a large sql statement to store a intermediate value > which could be used later in that query?
Yes - by using a subquery, as you were shown. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users