Use an inner join
…But that only gives me everyth— wait
Oh, hell, no one pointed out you can AND inside an inner join. Duh.
“SELECT * FROM books INNER JOIN userbooks ON books.isbn10 = userbooks.isbn AND userid = #”
