title: Query returns nothing during inner join when one table empty
body: <p>I am creating a library management system.</p>
  
  <p>I am trying to query a SQL database through VB.NET with an inner join function, and return data to a datagridview, what I am looking for is a return of something, I do not know the best way to proceed.</p>
  
  <p>I have a table called <em>Onloan</em> that holds basic information about the loan, an id for the user <em>UNID</em>, a ISBN for the book, start and end dates along with returned date, then inner joined with the enrolment table, for the user, and catalogue table, for the books, to create a full picture of what loan is active, for what and by who, but I have a reset function on the program that allows the administrator or senior librarian reset a specific table for example the users table, but the current code will not show any results is the users table is empty, obviously it will not because of the statement that I used, meaning that the dashboard will not be correct</p>
  
  <pre><code>SELECT OnLoan.UNID, OnLoan.ISBN, Catalogue.Title
    , Enrolment.Firstname + ' ' + Enrolment.Lastname As 'Full Name'
    , Enrolment.House + Enrolment.TutorGroup as Form
    , OnLoan.StartDate, OnLoan.EndDate
  FROM (Catalogue
  INNER JOIN OnLoan ON Onloan.ISBN = Catalogue.ISBN)
  INNER JOIN Enrolment ON Enrolment.UNID = OnLoan.UNID
  WHERE OnLoan.OnLoan = 1
  and OnLoan.EndDate &gt;= CONVERT(datetime, '" &amp; DateTime.Now.ToString("yyyy-MM-dd") &amp; "' )
  </code></pre>
  
  <p>The image is for the dashboard in the onloan and overdue datagrids I want information even if the data is not completed. Just place a "Unknown user" there or something.</p>
  
  <p><img src="https://i.stack.imgur.com/JJE0P.png" alt="image of dashboard"></p>
  
  <p>I just want information and references for areas I should look at, if you are able to edit my code and let me use it, that would be great, but any information and help you can provide would be appreciated.</p>