title: SQL Error: The multi-part identifier "tableName.ColumnName" could not be bound
body: <p>When <code>LEFT JOINing</code> tables in a SQL query, sometimes I need to reference multiple tables in the <code>ON</code> clause. For example:</p>
  
  <pre><code>SELECT p.Name, j.Job, s.Salary
  FROM PeopleTable p, JobTable j
  LEFT JOIN SalaryTable s ON s.PeopleID=p.PeopleID AND s.JobID=j.JobID
  </code></pre>
  
  <p>However, the above would give this error:<br></p>
  
  <blockquote>
    <p>SQL Error: The multi-part identifier "p.PeopleID" could not be bound.</p>
  </blockquote>
  
  <p>It seems that the <code>ON</code> clause in a <code>LEFT JOIN</code> statement can only "see" the last table listed in the <code>FROM</code> list.  Is this true?  Any workarounds?</p>