Thread: SQL Queries
View Single Post
Old 05-24-2009, 04:36 AM   #4
iain_benson
Connoisseur
iain_benson began at the beginning.
 
iain_benson's Avatar
 
Posts: 58
Karma: 37
Join Date: Oct 2008
Device: PRS-600
Boolean logic is quite a simple filter, it doesn't allow complex ones as in my first example.
Given
Book1,Author1,tag1
Book2,Author1,no tags
Book3,Author2,tag1
Book4,Author3,no tags

My query, using tag1 as the main search term, would pull out books 1, 2 & 3. With the current search/filter system I would have to filter on tag1, make a list of all the authors it returned, then clear the filter and re-filter on the complete list of authors.
iain_benson is offline   Reply With Quote