*’Cause I have a feeling there’s more to come
I just spent an hour or so figuring out why a long SQL query is returning 0 rows. Long as in,
SELECT books.isbn, title, lastname, firstname, publishername FROM books INNER JOIN authored ON books.isbn = authored.isbn INNER JOIN bookpersons ON authored.personid = bookpersons.personid INNER JOIN published ON published.isbn = books.isbn INNER JOIN publishers ON published.publisherid = publishers.publisherid WHERE title = "Brave New World"; |
I was already looking into derived relations and subqueries until I realized that tables published and publishers are empty.
I’m calling it a day. So much for populating published and publishers and testing if my query works. Haaaayyyy… OTL