title: How to minimize multiple sub queries using join?
body: <p>Can anyone come up with a better solution?</p>
  
  <pre><code>SELECT TITLE,BOR_NAME,BOR_ADDRESS FROM BOOK,BORROWER 
  WHERE BOOKID IN 
       (SELECT BOOKID 
        FROM BOOK_LOANS 
        WHERE BRANCHID IN 
              (SELECT BRANCHID 
               FROM LIBRARY_BRANCH 
               WHERE BRANCH_NAME='SHARPSTOWN'))
        AND CARDNO IN 
            (SELECT CARDNO 
             FROM BOOK_LOANS 
             WHERE DUEDATE=to_date(sysdate));
  </code></pre>
  
  <p>Any help?</p>