On 7/4/2013 5:29 PM, Paul Sanderson wrote:
select * from master as m, lookup as l where x >= start and and x < end and m.index = l.index
You might want to look at the RTree module: http://www.sqlite.org/rtree.html It's specifically designed to implement such range queries efficiently. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users