title: jpa query error:the multi-part identifier could not be bound
body: <p>I am using JPA custom query in Spring application in which I need to query one table multiple times.</p>
  
  <p>I write this query in repository:</p>
  
  <pre><code>@Query(value="SELECT *"+
  "FROM TBLSTUDENTEQUALITY as e"+
  "left join VLE_LOOKUP_DATA as di on e.DISABLE_ID=di.ID"+
  "left join VLE_LOOKUP_DATA as d on e.DOMICILE_ID=d.ID"+
  "left join VLE_LOOKUP_DATA as n on e.ETHNIC_ID=n.ID"+
  "left join VLE_LOOKUP_DATA as g on e.GENDER_ID=g.ID"+
  "left join VLE_LOOKUP_DATA as na on e.NATIONALITY_ID=na.ID"+
  "left join VLE_LOOKUP_DATA as s on e.SEX_ID=s.ID"+
  "left join VLE_LOOKUP_DATA as o on e.SEXORT_ID=o.ID"+
  "left join VLE_LOOKUP_DATA as r on e.RELIGION_ID=r.ID"+
  "where STUDENT_ID=?1",nativeQuery=true)
  public List&lt;StudentEquality&gt; getAll(Long ID);
  </code></pre>
  
  <p>This query runs successfully in sql server but in spring boot application it is producing error like:</p>
  
  <pre><code> java.sql.SQLException: The multi-part identifier "e.DISABLE_ID" could not be bound.
  </code></pre>
  
  <p>If I remove <code>e.disable-id</code> line it comes on next line.I have explored many resources mostly suggest that may be column or table name for this isn't present but if this is the case it should give error in SQL server too.</p>