I was looking to store this whole query inside a view and just query the view from outside sqlite.
Is there a way to inside a large sql statement to store a intermediate value which could be used later in that query? Simon Slavin-3 wrote: > > > On 6 Feb 2010, at 1:54pm, personalt wrote: > >> I realize this works fine for this query but is there a way to to do this >> by >> passing the results from one query to the second? I have some more >> complex >> calculations coming up where I think this would be an easier way to go > > Yes, you use whatever programming language you're using to execute your > SQL queries. That's what programming languages are for. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Passing-Value-from-one-query-to-another-tp27478736p27480046.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users