title: The multi-part identifier could not be bound. Sql Server
body: <p>I am not able to query it is showing me error messages.</p>
  
  <blockquote>
    <p>Msg 4104, Level 16, State 1, Line 17 The multi-part identifier
    "D1.DesignationId" could not be bound. Msg 4104, Level 16, State 1,
    Line 18 The multi-part identifier "A.EmployeeId" could not be bound.
    Msg 4104, Level 16, State 1, Line 18 The multi-part identifier
    "D1.EmpId" could not be bound. Msg 4104, Level 16, State 1, Line 21
    The multi-part identifier "A.EmployeeId" could not be bound.</p>
  </blockquote>
  
  <p>My query code is:</p>
  
  <pre><code>SELECT     
      RequisitionAuthoritySignatury.ReqSampleDetailsId, 
      RequisitionAuthoritySignatury.ReqId, 
      D1.EmpName, 
      D1.DesignationId, 
      G.Name, 
      RequisitionAuthoritySignatury.PreparedBy
  FROM 
      RequisitionAuthoritySignatury 
      INNER JOIN AuthoritySignatury A ON RequisitionAuthoritySignatury.PreparedBy = A.AuthoritySignaturyId 
      INNER JOIN AuthoritySignatury B ON RequisitionAuthoritySignatury.PreparedBy = B.AuthoritySignaturyId 
      INNER JOIN AuthoritySignatury C ON RequisitionAuthoritySignatury.PreparedBy = C.AuthoritySignaturyId 
      INNER JOIN EmployeeMaster D1
      INNER JOIN EmployeeMaster E
      INNER JOIN EmployeeMaster F
      INNER JOIN DesignationMaster G 
          ON D1.DesignationId = G.DesignationId 
          ON A.EmployeeId = D1.EmpId
      INNER JOIN DesignationMaster H 
          ON E.DesignationId = H.DesignationId 
          ON A.EmployeeId = E.EmpId
      INNER JOIN DesignationMaster I 
          ON F.DesignationId = I.DesignationId 
          ON A.EmployeeId = F.EmpId
  WHERE 
      RequisitionAuthoritySignatury.ReqId=158 AND 
      RequisitionAuthoritySignatury.ReqSampleDetailsId=260;
  </code></pre>