title: Multi part identifier could not be found
body: <p>I have this query that is throwing.</p>
  
  <pre><code>SELECT 
      Firm._Name, Broker._name
  FROM 
      Firm, Broker
  INNER JOIN 
      Employer AS emp ON emp.firmid = Firm.firmid 
  INNER JOIN 
      emp ON emp.brokerid = Broker.brokerid
  WHERE 
      emp._name = 'xxx';
  </code></pre>
  
  <blockquote>
    <p>Msg 4104, Level 16, State 1, Line 4<br>
    The multi-part identifier "Firm.firmid" could not be bound.</p>
  </blockquote>
  
  <p><code>Firm</code> table:</p>
  
  <pre><code>firmid
  _Name
  </code></pre>
  
  <p><code>Broker</code> Table:</p>
  
  <pre><code>brokerid
  firmid
  _name
  </code></pre>
  
  <p><code>Employer</code> Table</p>
  
  <pre><code>employerid
  brokerid
  firmid
  _name
  </code></pre>
  
  <p>Thanks!</p>