title: Inner join equivalent of this subquery?
body: <p>I have these tables</p>
  
  <p><code>BooksCatalog</code><br>
  <code>[BookCatalogID],[BooksCatalogBookID],[ReceivedFrom],[BillNo],[billdate]</code></p>
  
  <p><code>Books</code><br>
  <code>[BookID],[BookTitle],[ISBN],[ISBN13],[BookAuthorID],[BookPublisherID],[YearPublished],[NumberOfPages],[Volume],[edition],[Price]</code></p>
  
  <p><code>Authors</code><br>
  <code>[AuthorID],[AuthorName],[AuthorCityID],[AuthorStateID],[PhoneNumber],[Email],[Website]</code></p>
  
  <p>I am running this query, </p>
  
  <pre><code>SELECT Books.BookTitle FROM Books 
          INNER JOIN Authors ON Authors.AuthorId=Books.BookAuthorID
          WHERE Books.BookID IN 
          (SELECT BooksCatalog.BooksCatalogBookID FROM BooksCatalog
          WHERE BooksCatalog.billdate = (SELECT MIN(BooksCatalog.billdate) FROM BooksCatalog))
          AND
          AUTHORS.AuthorName = @AuthorName;
  </code></pre>
  
  <p>as it is using 2 subqueries, I am getting a feeling that its not optimized, and it could perform better if used with equivalent inner join. So, what's the equivalent inner join for this? What I am doing is find the first of of given author that was added to the library.</p>