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

Reply via email to