Hahaha! A coincidence! Thanks! On Mon, Dec 13, 2010 at 6:30 PM, Gerry Snyder <mesmerizer...@gmail.com>wrote:
> On 12/13/2010 7:55 AM, steve mtangoo wrote: > > Yes, ID is autoincrement and hence sequential. > > The problem with using it is, I have to know the ID of the beginning (for > eg > > Book 1 Chapter 1 Verse 2) and the Id of the end (eg Book 4 Chapter 10 > Verse > > 3). Then Simple BETWEEN will resolve it. > > > > Thanks for replying! > > > > select verse from Bible where ID between (select ID from Bible where > book = 1 and Chapter = 1 and Verse = 1) and (select ID from Bible where > book = 2 and Chapter = 3 and Verse = 1) > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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