title: Access query across multiple tables with potentially non-existent related records
body: <p>I'm working on an MS Access 2010 database, and I have 5 tables I need to query.</p>
  
  <p>Table 1 has an ID, name, a several other unrelated columns.<br>
  Tables 2 through 5 have their own IDs, the ID of the related record from Table 1, a date field, and then other miscellaneous fields.</p>
  
  <p>I am trying to build a query to return the ID and name from table one, and the dates from tables 2-5.</p>
  
  <p>I didn't really think that there would be any issues, but here I am. I have not done anything special with the query, just added the tables/columns to the Query Design view.</p>
  
  <p>The query is working, sort of, however if the user has not created a related record with a matching ID in any of the related tables that record in table a is ignored.</p>
  
  <p>I would like the query to return all records from table 1, and show me the dates from tables 2-5, even if one or all of them do not have a related entry.</p>
  
  <p>I hope this makes sense... Any assistance is greatly appreciated! Thanks! :)</p>