title: Sql - the multi-part identifier cannot be bound
body: <pre><code>select distinct 
     page0.MatterType, 
     page0.Name, 
     page0.MatterNo, 
     page0.security, 
     page0.serial,      
     page6.TribCaseNo, 
     contact0.Name as Cname
  from 
     page0, page6, page14
  left join 
     contact0 on page0.PrimaryContact = contact0.linkserial
  where 
    page0.serial = page6.CaseSerial 
  AND page0.serial = page14.CaseSerial 
  AND (page14.staffmember = '100001^24' and page14.status != 'Inactive') 
  AND page0.status != 'Closed'
  </code></pre>
  
  <p>I keep getting an error that </p>
  
  <blockquote>
    <p>the multi-part identifier page0.PrimaryContact could not be bound.</p>
  </blockquote>
  
  <p>I've checked the syntax and the spelling and both seem to be correct.</p>
  
  <p>Thanks!</p>