Rich, It is good to hear from another ecologist. You will probably understand my need (desire) to make an electronic plant key. I've had to carry Too Many large and heavy plant keys with me in the field. Something on a PDA or a smart phone would be much easier to carry and probably appreciated by many. But not really appreciated much by the general public. When I ran the stepwise regression analysis for my masters degree in the mid 1970s I was using a mainframe computer and punch cards. You sure don't see those much anymore. I probably still have the book SAS76 somewhere. Bob
--- On Sun, 9/12/10, Rich Shepard <rshep...@appl-ecosys.com> wrote: From: Rich Shepard <rshep...@appl-ecosys.com> Subject: Re: [sqlite] New to SQLite and I have a question To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Sunday, September 12, 2010, 12:01 PM On Sun, 12 Sep 2010, Bob Keeland wrote: > Access may not be the best database for my programs, but then again my > needs are not that great. I just need to search a database and then search > the results of the first search, then search the results of the second > search, etc. That sounds simple to me, but I'm an ecologist not a > professional programmer. Bob, I, too, am an ecologist, but I've been coding applications since 1972. :-) FORTRAN, C, and now Python. I'll suggest a SQL language book as your first purchase. Your description above suggests that nested sub-queries in the SELECT statement are what you need to learn. Learn SQLite, too, and you won't go wrong as your needs grow. Rich _______________________________________________ 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