SQL query help?
I want to use MCS to do the following, but without seeing the db structure, I'm not quite sure how to word it properly. What I WANT is to: SELECT * FROM books WHERE author IN (SELECT author WHERE #category='>Purchased'). So, "find all the books where I've purchased at least one book by that author, for any author in my library".
This plugin does so many things that I want to do, but no matter how many times I read the tutorial, I'm still confused. Any help is GREATLY appreciated!
|