Puneet Kishor <[email protected]> wrote: > steve mtangoo wrote: >> I have a script that is supposed to query the Bible scriptures between two >> intervals. My table is named Bible and have columns: ID (int), Book (int), >> Chapter(int), Verse (int) and Scripture(text). >> >> Now the books are unique i.e. 1-66 but chapters keep repeating, and so do >> verses. Now suppose I want to get scripture between book 1 chapter 1 verse 1 >> and book 2 chapter 3 Verse 1, how do I go about? > > > SELECT Scripture > FROM Bible > WHERE > Book > 0 AND Book < 3 AND > Chapter > 0 AND Chapter < 4 AND > Verse > 0 AND Verse < 2
This excludes, for example, book 1 chapter 10. I'm pretty sure the OP wanted it included. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
