title: Select all data include another table even if null
body: <p>Setup:
  (1) Employee table (employeeID, firstName, lastName)</p>
  
  <p>(1) Shoe table (shoeID, Employee_employeeID, shoeName, shoeColor, shoeBrand)</p>
  
  <p>I want to select all rows in Employee table and even if there is no matching EmployeeID (Employee_EmployeeID) in the shoe table display that entire row anyway. Example desired output:</p>
  
  <pre><code> EmployeeID  | firstName    | lastName    | shoeName     |   shoeColor  | shoeBrand
  
   1            John           Smith         AirMax2          Red          Nike
   2            Ronald         Mcdonald      null             null         null
   3            James          Knight        null             null         null
   4            Cindy          Smith         Pump             Brown        Cole Haan
  </code></pre>
  
  <p>I have tried a lot of different joins and I will get duplicate rows for each Employee.</p>