This tutorial shows how to create tables in SQLite, and then how to extract data from them using the SQL joins and filters. For more information check out http://www.squidoo.com/sqlitehammer.
This is part of my Squidoo Lens at http://www.squidoo.com/sqlitedatabasedesign#module46058772
For more information on SQLite, see
http://www.squidoo.com/sqlitehammer
http://www.squidoo.com/sqliteprogramming
http://www.squidoo.com/sqlitetutorial
http://www.squidoo.com/sqlitedatabasedesign