title: The multi-part identifier could not be bound
body: <p>trying this </p>
  
  <pre><code>select tblPersonalInfo.companyname, tblJobBudget.title,tblJobBudget.lastmodifiedby,
  tblJobAdv.advtitle, tblJobAdv.userId,       
  tblApplication.advid, tblApplication.position
  from tblJobAdv 
  inner join tblApplication
  ON tblJobAdv.advid = tblApplication.advid
  inner join tblPersonalInfo
  On tblJobBudget.lastmodifiedby = tblPersonalInfo.userid
  </code></pre>
  
  <p>gives error</p>
  
  <pre><code>Msg 4104, Level 16, State 1, Line 8
  The multi-part identifier "tblJobBudget.lastmodifiedby" could not be bound.
  Msg 4104, Level 16, State 1, Line 2
  The multi-part identifier "tblJobBudget.title" could not be bound.
  Msg 4104, Level 16, State 1, Line 2
  </code></pre>
  
  <p>The multi-part identifier "tblJobBudget.lastmodifiedby" could not be bound.</p>