title: How to query all records from multiple tables with joins
body: <p>I have my main table <code>employee_rates_year</code>:</p>
  
  <pre><code>tier   skill   rate   year
  1      28      110    2019
  2      28      101    2019
  </code></pre>
  
  <p>my column <code>skill</code> is connected to an employees table and subcontractors table, for simplicity here is a shortened version of <code>tblEmployees</code>:</p>
  
  <pre><code>EMPLOYEEID   Skill   FullName
  1            28      Employee One
  2            28      Employee Two
  </code></pre>
  
  <p>and <code>tblSubcontractors</code>:</p>
  
  <pre><code>SUBCONTRACTORID   Skill   FullName
  1                 28      Sub One
  2                 28      Sub Two
  </code></pre>
  
  <p>I am trying to get a tier, rate and year show up for every individual employee &amp; subcontractor.</p>
  
  <p>I've tried using different joins but nothing seems to give me information with every employee/subcontractor. </p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT *
  FROM employee_rates_year
  left join tblsubcontractors on employee_rates_year.skill = tblsubcontractors.skill
  left join tblemployees      on employee_rates_year.skill = tblemployees.skill
  </code></pre>
  
  <p>The problem is that my query shows results like this:</p>
  
  <pre><code>tier    skill    rate    year    tblEmployees.FullName    tblSubcontractors.Fullname
  
  1       28       110     2019    Employee One             Sub One
  2       28       101     2019    Employee Two             Sub Two
  </code></pre>
  
  <p>Whereas I am trying to get:</p>
  
  <pre><code>tier   skill   rate   year   tblEmployees.FullName   tblSubcontractors.FullName
  
  1      28      110    2019   Employee One
  1      28      110    2019                           Sub One
  2      28      101    2019   Employee Two
  2      28      101    2019                           Sub Two
  </code></pre>
  
  <p>I have also tried using <code>WHERE</code> to try and differentiate between the two tables and pick individual records.</p>