View Single Post
Old 08-01-2024, 07:47 PM   #329
shauntih
Member
shauntih began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Sep 2013
Device: Kindle
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!
shauntih is offline   Reply With Quote