title: Microsoft Access query - not returning all data
body: <p>Suppose I have the following tables:</p>
  
  <ul>
  <li>Table1: FLP, FNAME, LNAME</li>
  <li>Table2: FLP, Job, Company, Location</li>
  <li>Table3: FLP, Status, Salary, Position</li>
  </ul>
  
  <p>All are linked together by the FLP.</p>
  
  <p>When I am trying to query to get all fields in all tables suppose my query is the following</p>
  
  <pre><code>Select *
  From Table1, Table2, Table3
  Where Table1.FLP = Table2.FLP AND Table1.FLP = Table3.FLP
  </code></pre>
  
  <p>However, suppose that one of the tables does not contain information or the record thus doesn't have an FLP.</p>
  
  <p>For example: If i inserted into table1 <code>johndoe1, john, doe</code>,<br>
  and into table2 <code>johndoe1, developer, comp, usa</code>,<br>
  but did not insert anything into table 3 since the information is optional</p>
  
  <p>my query will not fetch the result since it will fail at <code>Table1.FLP= Table3.FLP</code></p>
  
  <p>Sometimes <code>table2</code> does not contain any information</p>
  
  <p>If i tried my query as follows</p>
  
  <pre><code>Select *
  From Table1, Table2, Table3
  Where Table1.FLP = Table2.FLP OR Table1.FLP = Table3.FLP
  </code></pre>
  
  <p>then it will fetch all the results but mixes them up for example johndoe1 will have information from table3 that isn't equal to johndoe1 thus creating multiple results with different values.</p>
  
  <p>If needed more explanation or the real table design please let me know.</p>